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

Join the forum, it's quick and easy

SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India
SriniForum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Best SQL queries

Go down

Best SQL queries Empty Best SQL queries

Post by srini 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

Back to top Go down

Best SQL queries Empty Re: Best SQL queries

Post by srini 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

Back to top Go down

Back to top


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