how to display ducplicate records / row ?

newk · #1 (**permalink**) 05-11-04, 22:53

hi,

how can i display duplicate records?

thanks

Pat Phelan · #2 (**permalink**) 05-12-04, 01:24

What do you define as a "duplicate" row? The obvious answer is:

Code:

SELECT columnList
   FROM myTable
   GROUP BY columnList
   HAVING 1 < Count(*);

You'll need to replace columnList with a comma separated list of the columns that you find interesting.

-PatP

trieder · #3 (**permalink**) 05-12-04, 11:02

Just

SELECT *
FROM Table_Name;

Should do the trick, replace star with column names. If you're doing a join, then obviously one piece of the query is causing things to not be displayed. Show us your query.

Internet Services

Web Development

Digital Marketing

Consumer Tech