how to check the 3rd max salary from an employee table?
Answer Posted / somanath
select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)
Is This Answer Correct ? | 34 Yes | 7 No |
Post New Answer View All Answers
What are the possible values that can be stored in a boolean data field?
What is prepared statement in sql?
What is a string data type in sql?
What is the difference between join and natural join?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What are the differences between implicit and explicit cursors?
What is a loop in sql?
Explain two easy sql optimizations.
Does truncate free space?
Why are sql stored procedures used?
What is sql profiling in oracle?
How to get each name only once from an employee table?
What are the parameter modes supported by pl/sql?
what is innodb? : Sql dba
what is a composite primary key ? : Sql dba