By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

How to eliminate duplicate records in a query?

P: 51
I am trying to generate a query from a table which has multiple dublicate records, but in the query, I don't want to show the duplicate record. I just want the duplicate records to show only one time.
Any idea?
Thanks!
Dec 5 '06 #1
Share this Question
Share on Google+
4 Replies


blyxx86
100+
P: 256
I am trying to generate a query from a table which has multiple dublicate records, but in the query, I don't want to show the duplicate record. I just want the duplicate records to show only one time.
Any idea?
Thanks!
I believe there is a "SELECT DISTINCT" SQL command, look that up and you should come across something.

I looked it up, and this the SQL command I came across:
Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCT column_name(s)
  2. FROM table_name
  3.  
Dec 5 '06 #2

P: 51
Thanks!
I've just tried your idea, it still showed all the records, I think I need to add some criteria in the Account# so that it won't show duplicate records, but have no idea
Any idea?
Thanks!
Dec 5 '06 #3

P: 51
Hey, actually it working
Thanks!
Elaine
Dec 5 '06 #4

NeoPa
Expert Mod 15k+
P: 31,660
See the other thread for further details.
Try to remember not to post the same question twice Elaine :( - we moderators have enough on our hands as it is. (I expect this one was accidental so no problem.)
Dec 5 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.