Re: Need SQL query for
Posted By: Priyank at 10:47:24 on Friday the 13th of July 2007
Use it *************************************** $sql = 'SELECT * , (' . ' SELECT max( id )' . ' FROM tblname' . ' ) AS maxid' . ' FROM `tblname`' . ' GROUP BY id' . ' HAVING id > ( maxid -5 ) ';
***************************************