How to retrieve a second highest salary from a table?
Note:Suppose salaries are in duplicate values
eg:
Name Sal
Malli 60000
Pandi 60000
Rudra 45000
Ravi 45000
- 10 Answers
- 13193 Views
- Mind Tree, Polaris, Sonata, I also Faced
- E-Mail Answers
Answer Posted / bibu
This IS HELP FULL 1ST ,2ND,3RD,4TH ANY HIGHEST SALARY U WRITE THIS QUERY.
SELECT * FROM Table_Name ALIAS_NAME 1
WHERE &N=(
SELECT COUNT(DISTINCT(WHICH COL U WANT THAT COL_NAME))
FROM Table_Name ALIAS_NAME 2
WHERE ALIAS1.CoL<=ALIAS2.Col
)
EX:
SELECT * FROM Emp E1
WHERE &N=(SELECT COUNT(DISTINCT(Sal))
FROM Emp E2
WHERE E1.Sal<=E2.Sal)
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Is sql a oracle?
what is isam? : Sql dba
What is the use of count (*) in sql?
How are functions and procedures called in PL/SQL?
What does fetching a cursor do?
What is relationship? How many types of relationship are there?
What is difference between table and view?
Why is normalization important?
What are the types of optimization?
What are types of indexes in sql?
what are aggregate and scalar functions? : Sql dba
What is function and procedure?
How do I know if I have sql express or standard?
What does closing a cursor do?
what are the features and advantages of object-oriented programming? : Sql dba
