Think you want: Select max(job_id) from job_log_2004
> I'm trying to select the last record (row) in a db. I'm trying with a > select: > Select * from job_log_2004 where job_log_2004.JobID = (select > max(job_log_2004.JobID) from job_log_2004) and it fails. The part about > select max works and returns a number. What on earth am I doing wrong? > Or is there an easier way to return the last record? Thanks > > Thanks, > James > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
