Same data in field

  • Thread starter Thread starter Viv
  • Start date Start date
V

Viv

I have a fieid that has mulitlple instances of the same
value. I want to run a query showing only one instance
of this value. It doesn't matter about the rest of the
data. Can someone tell me how can I do this.
Thanks
Viv
 
Whereas
SELECT column1 FROM Table1
will return all rows where column1 is not Null
SELECT DISTINCT column1 FROM Table1
will only return a row for each unique value of column1

Hope This Helps
Gerald Stanley MCSD
 
Back
Top