Select name, count(*) from tablename group by name having count(*)>1
Write a query to find the duplicate rows from a table?
Subscribe / Share
Subscribe
- Help me come up with interview questions for Frank Warren!?
- aieee questions ..plz help answering them..with explainations if possible?
- Salary question, what would you advise?
- Any accountants out there that wouldn’t mind answering some questions for a career interview?
- Biology Questions – Evolution?
- Paterns of Inheritance Questions?
- Does anyone know interview questions regarding webmaster position at Google Inc.?
- a couple of biology lab questions?
- I have some questions about inheritance and coming of age.?
- ag_iitkgp on aieee questions ..plz help answering them..with explainations if possible?
- jennyrescued on Help me come up with interview questions for Frank Warren!?
- Greg K on Salary question, what would you advise?
- john w on Salary question, what would you advise?
- Joe on Does anyone know interview questions regarding webmaster position at Google Inc.?
- Jackson D on Any accountants out there that wouldn’t mind answering some questions for a career interview?
- Eric on Is it possible to become a medical assistant w/o the training class?
- Barbie Tovias on Java/J2EE Developers required@PUNE
- QUASAR on Biology Questions – Evolution?