Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.

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

ketan_kashyap@yahoo.co.in · 10-03-08, 02:22 PM

Quote:

Originally Posted by radhika_btech

Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.

select name, count(name)
from table_name
group by name
having count(name) > 1

TILAK · 19-09-08, 03:05 PM

SELECT ID,COUNT(*) FROM EMP2 E WHERE ROWID >(SELECT MIN(ROWID) FROM EMP2 R WHERE E.ID=R.ID)GROUP BY E.ID

IF U HAVE BELOW TABLE

EMP

ID
10
10
20
20
20

23-01-07, 09:36 PM	#1 (permalink)
radhika_btech Senior Member Join Date: Jan 2007 Age: 27 Posts: 283 Thanks: 0 Thanked 2 Times in 2 Posts Thanks: 0 Thanked 2 Times in 2 Posts Rep Power: 4	Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated. Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.

19-09-08, 03:05 PM	#3 (permalink)
TILAK Junior Member Join Date: Sep 2008 Age: 24 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated. SELECT ID,COUNT(*) FROM EMP2 E WHERE ROWID >(SELECT MIN(ROWID) FROM EMP2 R WHERE E.ID=R.ID)GROUP BY E.ID IF U HAVE BELOW TABLE EMP ID 10 10 20 20 20

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
interview Q&A asked in winrunner	Spoorthi	Testing Tools & QA	80	22-11-08 11:48 PM
Mega Free Download S/W Links A-Z	yathish	OTHERS	513	30-09-08 02:49 PM
Some VBScript Functions..	kiran2710	Testing Tools & QA	5	11-11-07 07:05 PM
Sql - How to display duplicate rows in a table?	radhika_btech	Oracle Interview / Technical Questions	1	28-01-07 02:07 AM
SQL SERVER 2000 QUESTIONS....	LALIT KUMAR	VB / ASP.NET Technologies	2	16-12-06 06:29 PM

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