select distinct returns duplicates 1

[brownfox]

I only want to return one row for driver_guide 46 but "select distinct driver_guide,driver_make..." returns both records:

[u]driver_guide| driver_make[/u] 
46          |Jaguar 
46          |Ford

Any help much appreciated.

 

[r937]

of course

the function of DISTINCT is to ensure that all result rows are unique

you have two columns in the SELECT

therefore you get only distinct combinations of those two values

in the example you show, those rows are unique

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[brownfox]

OK I get that but how do I just get just one row? Do I have to join the table on itself using an alias or something?

 

[ericbrunson]

No, just "select distinct driver_guide".

 

[hoinz]

... get just one row?
but which one?

You could use group by and aggregate functions,
something like this:

select driver_guide, min(driver_make)
from your_table
group by driver_guide;

hope this helps