Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153868 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / mohd. rashid
SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Design database draw er diagram for a certain scenario ?
Does oracle charge for java?
what is reindexing?
How can I get column names from a table in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the differences between char and nchar in oracle?
How to add a new column to an existing table with a default value?
How to use "if" statements on multiple conditions?
Explain rename?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain what are synonyms used for?
Difference between varchar and varchar2 data types?
How do I uninstall oracle client from windows?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is oracle analytical function?
