find out the third highest salary?
Answer Posted / sanjeev kumar p
select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)
Is This Answer Correct ? | 99 Yes | 51 No |
Post New Answer View All Answers
How to use "startup" command to start default instance?
How to add another datafile to a tablespace?
what are actual and formal parameters?
What is the max number of columns in an oracle table?
What is control file used for?
What is instant client oracle?
How to connect to oracle using service name instead of sid?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are the four Oracle system processes that must always be up and running for the database to be useable?
State any two functions of oracle?
How to filter out duplications in the returning rows using oracle?
What do you mean by group by clause?
How to use null as conditions in oracle?
List out the components of logical database structure of oracle database.
How to select an oracle system id (sid)?