jatindersingh.wordpress.com

------------------------------------------------------------------------------- Jatinder Singh | Create Your Badge ------------------------------------------------------------------------------- SELECT max(id) from rs_category where id not in (SELECT max(id) from rs_category) to find nth highest record: (select distinct(salary) from employee order by salary desc limit n-1,1 n->find the nth largest) -------------------------------------------------------------------------------