SQL Queries #5 Fetch duplicate records
- Prasanta Paul
- Apr 30, 2018
- 1 min read
QUERY TO FETCH DUPLICATE records..
Query:-
" Select empid, project,salary, Count(*) form sal GROUP BY empid,project, salary HAVING COUNT(*) >1"
[ For the table structure please visit sql query 1. ]
Comentários