how to find nth lowest salary

Answer Posted / mohd javed

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)

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which key can be used to execute a query in the query editor?

398


What is the port number for postgresql?

419


What is postgresql? Explain the history of postgresql.

444


What is postgresql written in?

480


What is psql command?

459






How do you delete a row in a table?

411


Can postgres handle big data?

453


What are the benefits of postgresql?

442


Does aws support postgresql?

527


How does db indexing work?

480


What is use of postgresql?

395


What is the latest version of postgresql?

439


Is postgresql good?

458


How to execute postgres function in pgadmin?

608


How many rows can postgresql handle?

448