find out the third highest salary?
Answer Posted / karunakar varma
select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is oracle database 10g express edition?
What is program global area (pga) in oracle?
Explain drop constraint oracle?
Can multiple cursors being opened at the same time?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to create id with auto_increment on oracle?
Explain the use of ignore option in imp command.
How to turn on or off recycle bin for the instance?
What is the sid in oracle?
Explain rename?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is a tns file?
How a database is related to tablespaces?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?