find out the third highest salary?
Answer Posted / chandiran
select * from (select sal, rownum r from Employee
order by sal desc)
where r=3
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain overloading. Can functions be overloaded?
How to define an anonymous block?
What is the database name in oracle?
What is an oracle tablespace?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is system global area (sga) in oracle?
Explain the use of record option in exp command.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are the tools for Oracle ?
How to display employee records who gets more salary than the average salary in the department?
How to view existing locks on the database?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to use "in" parameter properly?
What is the use of aggregate functions in oracle?