Postgre Question:

How to find nth lowest salary?

Tweet Share WhatsApp

Answer:

For All SQL , Tested in PostgresSQL : Javedcc@gmail.com

SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)

Download Postgre PDF Read All 13 Postgre Questions
Previous QuestionNext Question
How many developers work on PostgreSQL?When will data in the data base is updated?