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!

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

How to use Distinct using 2 fields

Status
Not open for further replies.

JPCogAdmin

Programmer
May 22, 2006
110
US
Afternoon,

I'm wondering how to select data using distinct on 2 fields. I've only seen distinct(one.field) but not on two fields. How could I do that? Thank you.

-J
 
SELECT DISTINCT Field1, Field2 FROM Table. Or are you trying to do an aggregate? (Noting the parentheses).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top