Re: how to select second heigest salary...

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to select second heigest salary...
Date: 2006-04-06 06:43:53
Message-ID: 20060406064353.GA13156@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ===

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paolo Sala 2006-04-06 06:47:02 Re: help
Previous Message karthick muthu 2006-04-06 05:54:58 help