find out the third highest salary?
Answer Posted / abhay
Select Top 1 sal from (select distinct top 3 sal from emp
order by sal desc)a order by sal
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to connect the oracle server as sysdba?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
State some uses of redo log files?
Explain database link?
How to initialize variables with default values?
What is partitioned table in Oracle?
Explain the use of indexes option in exp command.
How to estimate disk space needed for an export job?
Design database draw er diagram for a certain scenario ?
What is transport network substrate (tns) in oracle?
How do we create privileges in oracle?
What is an external table?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to create a temporary table in oracle?
What is ADDM Advisor in Oracle?