Postgre Question:
Download Job Interview Questions and Answers 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)
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 Question | Next Question |
| How many developers work on PostgreSQL? | When will data in the data base is updated? |