Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153802 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / anirban mitra
SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
State and explain the different types of data models?
What is tns entry?
What are the original export and import utilities?
How to call a sub procedure?
What is a trigger oracle?
How to create a stored program unit?
Where do you use decode and case statements?
How to export several tables together?
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
How many categories of data types in oracle?
Explain how you would restore a database using RMAN to Point in Time?
How to end the current transaction in oracle?
What are the various types of snapshots ?
How to Truncate Table in Oracle
Explain oracle 12c new features for developers?
