SELECT DISTINCT or something else.

  • Thread starter Thread starter shawncraig
  • Start date Start date
S

shawncraig

I have a Table with 4 fields in it. Lets say (FName LName MName Age) If
I do a SELECT DISTINCT on FName LName MName I only get those 3 values
returned to me. Is there a way to see all 4 values but NOT include AGE
in the distinction?
 
Make your query a 'group by' query (by clicking the sigma/summation button).
FName, LName, and MName would all have "Group By" in the Total row. Change
the Age column to be something else, like Max or First.
 
Back
Top