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: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
