SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India

Best SQL queries

Go down

Best SQL queries

Post by srini on Fri Jul 25, 2014 1:58 pm

What is the SQL query to retrieve duplicate records? Wink

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

View user profile

Back to top Go down

Re: Best SQL queries

Post by srini on Fri Jul 25, 2014 2:03 pm

SELECT empno, count(empno) as total_empno
FROM emp
GROUP BY empno
HAVING COUNT(empno) > 1

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

View user profile

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum