find out the third highest salary?
Answer Posted / shivaprasad
Hi Every one,this query will helps you to find 1st or 2nd or
3rd or and so on salary from the employee table.
change inside distinct top (3) for respective results
select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to invoke the data pump export utility?
How to export several tables together?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to select some rows from a table in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How to update a table row with a record?
Is oracle the best database?
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
Explain the use of rows option in exp command.
What is the difference between translate and replace in oracle?
Describe the types of sub query?
What is archive log in Oracle?
What is the max number of columns in an oracle table?
What is meant by raw datatype?