Write SQL Query to find duplicate rows
Exercise
Correct!
SELECT FirstName, COUNT(1) as CNT
FROM CUSTOMER
code_here
SELECT FirstName, COUNT(1) as CNT FROM CUSTOMER GROUP BY FirstName HAVING COUNT(1) > 1
assert(line2 == l2);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l2 = rpls("GROUP BY FirstName HAVING COUNT(1) > 1");