Hi,
I need to select a max value for a group of records and I also need the
primary key for that record.

I am wondering if this can be done with a single query? e.g

Table_x

id count cat_id
1 10 1
2 20 2
3 35 2
4 15 1

with
SELECT id, cat_id, max(count)
FROM table_x
GROUP BY cat_id

I would probably get the following result

id cat_id max(count)
1 1 15
2 2 35
and what I would like to get is

id cat_id max(count)
4 1 15
3 2 35

Is there a way to do this with single query ?

cathy
www.nachofoto.com