Using MAX function to fetch primary id

[Cathy Fusko]

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