Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361147 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
Please put the below query, u will get the second highest
salary of the table :---
select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;
| Is This Answer Correct ? | 488 Yes | 264 No |
Post New Answer View All Answers
How many types of normalization are there?
What is sql architecture?
Does sap use sql?
Can we insert in sql function?
Why select is used in sql?
Explain foreign key in sql?
How to create an array in pl/sql?
What is the difference between Union and Union all. Which is faster.
How can you select unique records from a table?
What is view explain with example?
Is sql easier than java?
What is bind variable in pl sql?
What is a pdo connection?
How do I run a pl sql procedure in sql developer?
How long will it take to learn pl sql?
