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

2006-04-05 Thread A. Kretschmer
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; http://www.postgresql.org/docs/curre

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

2006-04-05 Thread deepak pal
hi   how to select second heigest salary from employee  table field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)