how to find nth lowest salary
Answers were Sorted based on User's Feedback
Answer / liju
nth lowest
nth lowest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =
(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE b.sal<a.sal);
nth highest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =
(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE b.sal>a.sal);
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / hari.sidd
SELECT DISTINCT (A.sal) FROM EMP A WHERE &N =
(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE a.sal>=b.sal);
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
Answer / ezhumalai
with cte
as
(
select Salary,row_number() over ( order by Salary asc)rnt from EMP
)select * from cte where rnt=2
Is This Answer Correct ? | 2 Yes | 0 No |
What language is postgresql written in?
What is blob in postgresql?
What is inverted file ?
What is postgis and postgresql?
Is postgresql secure?
Why are stored procedures used?
How to import sql file in postgresql pgadmin 4?
Is primary key indexed by default?
What is stack builder?
What is sequelize?
What does the option psql -l of PostgreSQL display?
Compare ‘postgresql’ with ‘nosql’?