Postgre Question:
Download Questions PDF

How to find nth lowest salary?

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 Interview Questions And Answers PDF

Previous QuestionNext Question
How many developers work on PostgreSQL?When will data in the data base is updated?