« Mysql: Java Web App and MySql 5.x UTF-8
RegEx: Best RegEx Eclipse Plugin QuickRex »

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;

Posted: Saturday, November 8th, 2008
Tags: Sql.
Actions: RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Sql: Select rows with duplicate values (select, count, group by, having)”

  1. Martha Says:
    January 7th, 2009 at 10:25 pm

    hey, thanks! this helped very much!

Leave a Reply