Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150731 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sapna rawal
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary ;
n=3.In this case.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain oracle data types with examples?
What is a sub query and what are the different types of subqueries?
What is the best way to do multi-row insert in oracle?
What are the parameters that we can pass through a stored procedure?
What is Data Dictionary Cache in Oracle?
How to load a large xml file?
How to omit columns with default values in insert statement in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is a Garbage Collection? and what is full recursive Garbage collection?
How to create a table index?
How to connect to a local oracle 10g xe server?
What happens to the current transaction if the session is killed?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to delete multiple rows from a table in oracle?
Will you be able to store pictures in the database?explain.
