Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147713 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / santhoshkumar
select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How to write date and time interval literals in oracle?
How many types of tables are there in oracle?
What is merge statement used for?
What is literal?
How to create a single index for multiple columns?
What is a snapshot log?
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.
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.
How to retrieve values from data fields in record variables?
Explain table?
How to enter a new row into a table interactively?
What is a dead lock in oracle?
What is clustered table in Oracle?
Explain an extent?
How to assign a table row to a record variable?
