|
Home > Archive > PostgreSQL Discussion > April 2006 > how to select second heigest salary...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to select second heigest salary...
|
|
| deepak pal 2006-04-06, 3:26 am |
| 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)
| |
| A. Kretschmer 2006-04-06, 3:26 am |
| 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/curr....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 majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|