Re: How to select the max value

[Daniel Kasak]

Mauricio Pellegrini wrote:

>Hi,
>I need to select the max value from a set of records but I also need the
>primary key for that record.
>
>The problem is that the record id may not be the same as the record max
>value for the column as in the following example:
>
>Table_x
>
>Id	x_col	date_col
>1	1	2005-04-11
>2	1	2005-03-10
>3	1	2005-04-12
>4	1	2001-01-01
>
>with 
>	SELECT id, x_col, max(date_col) 
>	 FROM table_x 
>	 GROUP BY x_col
>
>I would probably get the following result 
>
>Id	x_col	date_col
>4	1	2005-04-12
>
>and what I would like to get is 
>
>Id	x_col	date_col
>3	1	2005-04-12
>
>  
>
That *is* what you'd get. The max() function works on an individual
column, not on all columns at once.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au