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

0 Members and 1 Guest are viewing this topic.

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 352
  • 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
134 Views
Last post October 01, 2008, 01:56:05 AM
by arpee
0 Replies
153 Views
Last post October 01, 2008, 02:31:56 AM
by arpee
0 Replies
817 Views
Last post November 27, 2008, 02:02:31 AM
by MrSpecialist
0 Replies
89 Views
Last post January 06, 2009, 07:17:19 AM
by rpmolecule
0 Replies
149 Views
Last post January 14, 2009, 01:53:42 AM
by Transformer10

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.