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

Best SQL queries

View previous topic View next topic 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

View previous topic View next topic Back to top

- Similar topics

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