Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show only the first duplicate within query

Status
Not open for further replies.
hrg

hrg

Programmer
Jan 8, 2009
46
US
Hi

I have a query which i am running but it shows duplicate data. What i want is to be able to do is to write, type or code a command which will take ONLY 1 of every duplicate entry and show it in the database query. I already have tried the group by in a cobination of fields but it does not show the write amount of data.

Thank you for any help.
 
Sort by date Sort by votes
Hi,
Type DISTINCT after SELECT in you're SQL then only unique rows come up
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
339
Andrzejek
Andrzejek
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
249
ziffer68
ziffer68
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
203
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
227
Moss100
Moss100
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
226
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top