Re: How to select the max value

2005-04-13 Thread Mauricio Pellegrini
age - > From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> > To: "MySql List" > Sent: Tuesday, April 12, 2005 7:35 PM > Subject: How to select the max value > > > > Hi, > > I need to select the max value from a set of records but I also need

Re: How to select the max value

2005-04-12 Thread Daniel Kasak
Daniel Kasak wrote: >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: >

Re: How to select the max value

2005-04-12 Thread Rhino
Rhino - Original Message - From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> To: "MySql List" Sent: Tuesday, April 12, 2005 7:35 PM Subject: How to select the max value > Hi, > I need to select the max value from a set of records but I also need the &

Re: How to select the max value

2005-04-12 Thread 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_co

How to select the max value

2005-04-12 Thread Mauricio Pellegrini
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