Sql: Select rows with duplicate values (select, count, group by, having)

November 8th, 2008 by jeremychone
select count(lastName), lastName from employee group by lastName having count(lastName) > 1;

Leave a Reply