distinct and order by trouble
Posted: Wed Aug 16, 2006 6:33 am
Hi!
I've got those collumns in PG database to work with - photoid, filename, challid, rating.
What's the query to get unique(distinct) challid and results ordered by rating? Can't figure it out. I need to fetch all given collumns as well.
Thanks for any hints
Cheers
Tom
I've got those collumns in PG database to work with - photoid, filename, challid, rating.
What's the query to get unique(distinct) challid and results ordered by rating? Can't figure it out. I need to fetch all given collumns as well.
Thanks for any hints
Cheers
Tom