DISTINCT values, plus key

PyroX

Alright, I have this query:

SELECT key, manufacturer,name,version FROM software ORDER BY name ASC

And now I need only DISTINCT values, but of course the key is auto incrementing, so I cannot just put DISTINCT in front, is there any way to do this in 1 query, what I se ein my head is:

SELECT key, DISTINCT(manufacturer,name,version) FROM software ORDER BY name ASC

Any help, and thanks.

Lars_Berg

So, which of the eligible keyValues do you want? Biggest smallest random?

select max(keyValue),
manufacturer,name,version
 FROM software 
group by manufacturer,name,version
ORDER BY name ASC

PyroX

All, so that I end up with all keys of unique data.

so if

[id] [name] [location]
1 aaaa 1234
2 aaaa 1234
3 aaaa 1234
4 bbbb 1234
5 bbbb 1234

the query would return:

1 aaaa 1234
4 bbbb 1234

The max() would do this?

Lars_Berg

Use min instead of max then.