how can i find out the duplicate raw in one table?

i don't have any primary key or forieign key set up..and
want to see if there's duplicate record there.

thanks guys..

Hi skwak2,

Lets say you have a table called Employees with FName, LName columns in it.
You can do something like this:

Select Distinct FName, LName From Employees Where FName+LName NOT IN (
Select FName+LName
From Employees
Group By FName, LName
Having Count(FName+LName) = 1)


Regards,

Vikram