How to delete repeated records in a query

ramk_1978 · March 5th, 2005, 01:16 PM

Hi,

My question is :

Table1:
Eid Ename
1 a
1 a
1 a
2 b
2 b

How to remove the repeated rows after deletion .

Ramkumar

A.D.Ramkumar

jbenson001 · March 6th, 2005, 01:45 AM

Is you question that you want to remove duplicate rows?

poojafalor · March 7th, 2005, 01:05 AM

Executed following statement in sequence:

Select distinct * into #tmpTable from Table1
Truncate Table Table1
Insert Into Table1 Select * from #tmpTable
Drop Table #tmpTable
Go

Cheers,
Pooja Falor

shahchi1 · March 7th, 2005, 11:23 AM

if you wanted to remove duplicate rows

SELECT Eid, Ename
FROM myTable
Group By Eid,Ename
Having Count(*) >1

ramk_1978 · March 10th, 2005, 12:09 PM

Need a Single DELETE query to this

Ramkumar

A.D.Ramkumar

shahchi1 · March 10th, 2005, 04:10 PM

DELETE
FROM MyTable
WHERE EID IN (SELECT EID FROM MyTable Group By EID,Ename Having Count(EID) > 1);

ramk_1978 · March 12th, 2005, 11:09 AM

Hi Sacchi,

Sorry, query didn't work perfectly.

I need an output after deleting repeated data.

Ramkumar

A.D.Ramkumar

shahchi1 · March 12th, 2005, 01:35 PM

Ramkumar, please provide us with a sample output

how you like your SQL to retrun your query output

ramk_1978 · March 13th, 2005, 11:45 AM

Hi,

output should be:

Eid Ename
1 a
2 b

Expecting your answer.

Ramkumar

A.D.Ramkumar

shahchi1 · March 13th, 2005, 02:44 PM

Are you using SQL server or Access?