Find out the 3rd highest salary?
Answer Posted / xyz
select a.sal from (select distinct(sal) from emp order by
sal desc)a where rownum=3
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
Can delete statement be rollbacked?
What is the difference between union and union all command?
what is data integrity? : Sql dba
What programs use sql?
What is an escape character in sql?
what is online transaction processing (oltp)? : Sql dba
What company owns postgresql?
What is schema in sql?
what is a tablespace? : Sql dba
How to select unique records from a table?
Can we write ddl statements in functions?
What is break?
What are the properties of a transaction?
What are the two types of exceptions.
Explain ddl statements in pl/sql?