how to find duplicate rows in a table based on specific column

programming faqs interview questions tech technical educational freshers guide preparation interviews hr telephonic

try another color:

try another fontsize: 60% 70% 80% 90%

User login

Thu, 08/19/2010 - 15:33 — Anonymous

Thu, 08/19/2010 - 15:34 — Anonymous

below query returns the rows duplicate firstnames in student table

select firstname, count(firstname) as cnt from student group by firstname having cnt>1