How to find nth lowest salary?
Submitted by: AdministratorFor 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)
Submitted by: Administrator
SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)
Submitted by: Administrator
Read Online Postgre Job Interview Questions And Answers
Top Postgre Questions
| ☺ | How does PostgreSQL compare to "NoSQL"? |
| ☺ | How to find nth lowest salary? |
| ☺ | How many developers work on PostgreSQL? |
| ☺ | How many PostgreSQL users are there, worldwide? |
| ☺ | What is the advantage of RAID? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
