Author Topic: SQL: Retrieve duplicate records  (Read 163 times)

0 Members and 1 Guest are viewing this topic.

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 368
  • Karma: +1/-0
    • View Profile
SQL: Retrieve duplicate records
« on: April 08, 2009, 07:18:05 AM »
SQL: Retrieve duplicate records

If select distinct removes duplicates, How do you do you do just the opposite?
For example the table contains
aaaaa
12345
12345
aaaaa
22222
33333
99999
99999

I only want to retrieve aaaaa, 12345, 99999 all others should not show up in results. Can this be done?

Techronnati | where technology never sleeps

SQL: Retrieve duplicate records
« on: April 08, 2009, 07:18:05 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
195 Views
Last post October 01, 2008, 01:56:05 AM
by arpee
0 Replies
196 Views
Last post October 01, 2008, 02:31:56 AM
by arpee
0 Replies
840 Views
Last post November 27, 2008, 02:02:31 AM
by MrSpecialist
0 Replies
248 Views
Last post January 14, 2009, 01:53:42 AM
by Transformer10
0 Replies
86 Views
Last post August 23, 2017, 11:04:25 AM
by rpmolecule

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.