duplicate rows in table

[almegaAkil]

which keyword can i use to create a query for removing duplicate rows

 

[crystalized]

distinct Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde

 

[almegaAkil]

i'll try try that but i was using a select query like this one

select [date], [location]
from [call info]
group by [date]
having (count([date])>1)

but that didn't work as it should have....

i even tried a delete query

i didn't even bother with distinct i thought i wouldn't be able to delete the duplicate rows...

 

[Earth]

select [date], count(*) as myCount
from [call info]
group by [date]
having (count(*)>1)

Has worked for me before..... but maybe not?

 

[tlbroadbent]

The following will identify the duplicates in the table based on two columns.

select [date], [location]
from [call info]
group by [date], [location]
having count(*)>1
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.