Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153864 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / dilip tiwari
THis is for Oracle
SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why does oracle 9i treat an empty string as null?
What is tns name?
What is a dynamic performance view in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
11. Display the client number and name and the client number and name of the person who referred that client.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
what are archived logs?
What is an Oracle Instance?
How to import one table back from a dump file?
How to update values on multiple rows in oracle?
How to drop a stored procedure in oracle?
Is postgres faster than oracle?
What is literal?
Use of an integrity constraint is better to validate data. Explain
How to sort the query output in oracle?
