find out the third highest salary?
Answer Posted / shashi kumar
Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to specify default values in insert statement using oracle?
When system tablespace is created?
How to use "out" parameter properly?
How to convert csv to table in oracle?
How to add another datafile to a tablespace?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is bulk collect in oracle?
What are the uses of linked server and explain it in detail?
Explain drop constraint oracle?
What happens to the current transaction if a ddl statement is executed?
What is SQL Tuning Advisor in Oracle?
What is the maximum limit on the number of columns in a table?
how to handle exceptions in post production
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are advantages of dateset in datastage?