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

Best SQL queries

Go down

Best SQL queries Empty 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

Best SQL queries Empty 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


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