Answers

Question and Answer:

  Home  Postgre

⟩ How to find nth lowest salary?

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)

 140 views

More Questions for you: