Sql - How to display duplicate rows in a table?

radhika_btech · 23-01-07, 09:35 PM

**sk_kireeti** · 28-01-07, 02:07 AM

let us assume we have some duplicate records in emp table and we can identify duplicates with empno. The the query looks like this.

Select * from EMP
where
rowid not in
(select max(rowid) from emp group by empno);

The above query displays all duplicate records.

Thanks,
Krishna

22-09-09, 06:23 PM

Thanks a lot thats a good one

23-01-07, 09:35 PM	#1 (permalink)
radhika_btech Senior Member Join Date: Jan 2007 Age: 28 Posts: 283 Thanks: 0 Thanked 6 Times in 6 Posts Rep Power: 5	Sql - How to display duplicate rows in a table? Sql - How to display duplicate rows in a table?
Offline

28-01-07, 02:07 AM	#2 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Posts: 2,379 Blog Entries: 4 Thanks: 118 Thanked 319 Times in 238 Posts Rep Power: 60	Re: Sql - How to display duplicate rows in a table? let us assume we have some duplicate records in emp table and we can identify duplicates with empno. The the query looks like this. Select * from EMP where rowid not in (select max(rowid) from emp group by empno); The above query displays all duplicate records. Thanks, Krishna __________________ Looking for trainees for a start up company
Offline

22-09-09, 06:23 PM	#3 (permalink)
Unregistered Unregistered Posts: n/a	Re: Sql - How to display duplicate rows in a table? Thanks a lot thats a good one

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sql - Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table.	radhika_btech	Oracle Interview / Technical Questions	1	17-09-09 07:03 PM
Sql - How to copy sql table.	radhika_btech	Oracle Interview / Technical Questions	1	26-01-07 08:23 PM
SQL SERVER 2000 QUESTIONS....	LALIT KUMAR	VB / ASP.NET Technologies	2	16-12-06 06:29 PM
How to insert values from one table to another table in sql server?	thirust5	ORACLE , SQL SERVER , SYBASE & Others	2	13-11-06 01:22 PM
hi.....	gomesh_2k6	VB / ASP.NET Technologies	8	07-09-06 12:38 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)