Обсуждение: how to select second heigest salary...

Поиск
Список
Период
Сортировка

how to select second heigest salary...

От
"deepak pal"
Дата:
hi
      how to select second heigest salary from employee  table field are id,name ,salary...plz help

--
Deepak Pal
Software Developer
Wicenet ltd.
Pune(M.H)

Re: how to select second heigest salary...

От
"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/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    ===