Hi...
Oues: I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Jan 28, 2012, 7:24 AM
SELECT fname, COUNT(*) AS 'Count'
FROM emp
GROUP BY fname
HAVING (COUNT(*) > 1)
Thanks