SQL Query

[mozingod]

Is there a way to know if duplicates of a record exsist after they've been surpressed with DISTINCT? So if there were I could link to another page to show all the results? Thanks. Darrell Mozingo

 

[GabeC]

I know you can accomplish what you are looking for but don't know the SQL for it.

Try asking in the SQL Server forum.
Thanks,

Gabe

 

[darpankumar]

You can first group by the fields from which you want the records to be unique. then add a field count(*) to retrieve the no. of rows in the group.

so this way you would be able to find out the no. of rows duplicate.

Such as :-

Select City,Weather,Count(*) as [No. of Common Rows] from tblCity Group by City,Weather

Darpan Gogia
darpan.kumar@india.birlasoft.com