OT: SQL Question ..., what's the easiest way to ... Options

[SirAndy]

SQL Question:

what's the easiest way to find duplicates in a table?

let's say i have a table (tbl_Users) with 20000 rows and the table has a column for the users email addy (sEmail) and i want to list all the accounts that have duplicate email addys.

i could run a script that takes each row and runs a count(*) on that addy, but that'll take forever.
anything simpler than that ???

(IMG:http://www.914world.com/bbs2/html/emoticons/idea.gif) Andy

[JB 914]

QUOTE (SirAndy @ Mar 17 2005, 05:34 PM)

QUOTE (Paul Heery @ Mar 17 2005, 05:17 PM) Then sort by the column you want. ok, how the heck do i sort a column in excel by name ???? (IMG:http://www.914world.com/bbs2/html/emoticons/confused24.gif) Andy

highlight the rows ( without the column header row at the top) then use data\filter\advanced filter to sort the data. they have a check box for unique records.

hope this helps