SQL Query for Dupes

Results 1 to 2 of 2

Thread: SQL Query for Dupes

  1. #1
    ichiro Guest

    Default SQL Query for Dupes

    Greetings! How do you Query A Column AND extract the Duplicates. <BR>ie. <BR>column 1 column2 <BR>-------- ------- <BR>dave south america <BR>george washington <BR>george washington <BR>bill america <BR>one bilion more columns. some with dupes. <BR><BR>I&#039;m trying to return: all of the duplicates. <BR><BR><BR><BR>I tried using a subquery: where not in (Distinct). But that just returns nothing. <BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Why Distinct is not giving you the result ??

    select distinct(firstname), lastname from tablename.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts