find out the third highest salary?
Answer Posted / sanil
select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is a Garbage Collection? and what is full recursive Garbage collection?
What are the various constraints used in oracle?
Is oracle an operator?
How to write date and time interval literals in oracle?
What is an oracle data file?
How to sort output in descending order in oracle?
What is coalesce function?
Describe an oracle table?
How to shutdown your 10g xe server from command line?
What is pragma autonomous transaction in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
definition of cluster and non-clustered index?
Is there an oracle sql query that aggregates multiple rows into one row?
Differentiate between translate and replace?
how can db_files > maxdatafiles since db_files is for instance and the later is for database