Display Only First Record of Repeating Records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in which two fields are repeated (Job Number and Service).
I'd like to create a query that only displays the first row of the repeated
records, so that the job number and service combination will be unique
(ideally it would display it as if a job can have multiple services, but
never have the same service twice). Any ideas? Thanks in advance.
 
You can do this by either creating a GROUP BY with those fields as the
total, or you can change the SQL from SELECT DISINCTROW to SELECT DISTINCT -
both will eliminate the duplicates.
 
Back
Top