[GENERAL] how to select second heigest salary...

hi how to select second heigest salary from employeetable field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)

Re: [GENERAL] how to select second heigest salary...

am 06.04.2006, um 10:19:21 +0530 mailte deepak pal folgendes: hi how to select second heigest salary from employee table field are id,name ,salary...plz help *untested* select id, name, salary from employee order by salary desc limit 1 offset 1;