Re: problem with distinct rows

Le mardi 08 mars 2005 à 11:04 +0100, Martijn van Oosterhout a écrit :
> You can put the DISTINCT ON() query as a subquery, and an ORDER BY in
> the outer query.

That was my first guess

select number.inventorynumber, name, first_name
from (select distinct on (inventorynumber) inventorynumber from works)
as number, artist, blah
order by name

???

> Sorting by surname is tricky since you need to tell the computer how to
> find it...

in artist table we have name, first_name etc so no problem there

Tony