Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153773 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
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
What are oracle functions?
What is the difference between sharding and partitioning?
What are joins, explain all types of joins?
Where do you use decode and case statements?
How would you go about verifying the network name that the local_listener is currently using?
Explain implicit cursor.
What is the difference between view and materialized view in Oracle?
Explain an extent?
What are the uses of Database Trigger ?
How to define a sub function?
Explain about integrity constraint?
How to create a testing table in oracle?
Define oracle database
20. Using a set operator, display the client number of all clients who have never placed an order.
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
