Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89987 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / janmejaya
select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary
Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain what are the advantages of views?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is the quickest way to export a table to a flat file?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How does the on-delete-cascade statement work?
How much memory your 10g xe server is using?
What is bulk copy or bcp in oracle?
What happens if the imported table already exists?
Explain oracle 12c new features for developers?
What is a table in oracle?
What is BBED in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
What are the uses of a database trigger?
What is a nvl function?
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.
