Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28773 Views
- I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
I write the query for this question using OLAP functions.
select e1.* from (select ename,sal,rank()
over(order by sal desc) rank from emp) e1
where e1.rank=2;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the limitation on the block size of pl/sql?
What is db journal file?
What is case function?
What is sql server and ase?
How does sql*loader handles newline characters in a record? : aql loader
What is a primary key example?
what is innodb? : Sql dba
What is rollback?
What is the main difference between sql and pl/sql?
Which nosql database is best?
Can you rollback after commit?
What is clause?
What is sharding in sql?
What are sql ddl commands?
What are the string functions in sql?
