Best SQL queries
Page 1 of 1
Best SQL queries
What is the SQL query to retrieve duplicate records?
srini- Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16
Re: Best SQL queries
SELECT empno, count(empno) as total_empno
FROM emp
GROUP BY empno
HAVING COUNT(empno) > 1
FROM emp
GROUP BY empno
HAVING COUNT(empno) > 1
srini- Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|