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 |
when will data in the data base is updated
What is pg_toast?
Does creating an index lock the table?
What is postgresql? Explain the history of postgresql.
Does toad work with postgres?
What is shared buffer in postgres?
How do you create a table in pgadmin 4?
How do you delete a row in pgadmin 4?
Compare ‘postgresql’ with ‘nosql’?
What is a sequence table in postgresql?
What is the difference between a primary key and a composite key?
Is postgresql cloud based?