Bits And Pix » Sql: Select rows with duplicate values (select, count, group by, having)

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.

Leave a Reply

About:

Micro blogs about code, design, and sys-admin stuff. If you want to be an author as well, email Jeremy Chone
Authors
- Bob Buffone
- Jeremy Chone
Blogroll
Categories
- Apache (1)
- Application Server (1)
- Dojo (1)
- Drupal (1)
- Eclipse (1)
- Enterprise (1)
- Freemarker (1)
- Groovy (1)
- Html (4)
- iBatis (1)
- IBM (1)
- Java (5)
- JavaScript (1)
- Joomla (1)
- jQuery (4)
- Linux (2)
- Mysql (4)
- Photoshop (1)
- Pics (3)
- RegEx (1)
- Sql (1)
- Subversion (3)
- Tomcat (1)
- Video (2)
- web2.0 (2)
- Windows (2)
- Wordpress (1)
- YouTube (2)