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/current/static/sql-select.html#SQL-LIMIT HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
