Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16621 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
What is sqlcommand?
Is primary key an index?
What is the use of desc in sql?
What is a ddl command?
What is acid property in a database?
What is oracle sql developer?
Is nosql relational?
Why do we use view in sql?
Why do we use sql constraints?
How can I delete duplicate rows?
write an sql query to find names of employee start with 'a'? : Sql dba
Do foreign keys improve performance?
What is oracle and pl sql?
what is recursive stored procedure? : Sql dba
How does cross join work?
