Write a query to find second highest salary of an employee.
Answer Posted / dilip
select rank,sal from(select rownum rank,distinct(sal) from
emp order by sal desc)
where rank=2;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the starting oracle error number?
What is a sql statement?
What is server name sql?
what are the differences between require and include, include_once and require_once? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
How do you determine the current isolation level? : Transact sql
What are the two parts of design view?
What are basic techniques of indexing?
What is pragma in sql?
What can sql server reporting services do?
Is left join faster than inner join?
Can we join two tables without common column?
What is pl sql variable?
How to use boolean type in select statement?
What is the difference between delete, truncate and drop command?