find out the third highest salary?
Answer Posted / paridhi
select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Where are the settings stored for each instance in oracle?
What is index in Oracle?
How can I see all tables in oracle?
How to convert character types to numeric types?
Which are the five query types available in oracle?
Differentiate between pre-select and pre-query?
How much memory your 10g xe server is using?
How to define an external table with a text file?
How to specify default values in insert statement using oracle?
What's dateware house and what's clustor with practicle example
What is literal?
Can you tell me how to add new column in existing views?how?How is possible?
How to write numeric literals in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?