List:General Discussion« Previous MessageNext Message »
From:Cathy Fusko Date:September 7 2007 7:11pm
Subject:Using MAX function to fetch primary id
View as plain text  
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

Thread
Using MAX function to fetch primary idCathy Fusko7 Sep
  • RE: Using MAX function to fetch primary idDaevid Vincent7 Sep
  • Re: Using MAX function to fetch primary idBrent Baisley11 Sep