how to find the second highest salary from emp table?
- 211 Answers
- 321293 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
Who developed sql?
How do I install microsoft sql?
Which is better stored procedure or query?
What is the execution plan in sql?
How to start the command-line sql*plus?
What is difference between joins and union?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is $$ in sql?
Can we use delete in merge statement?
What is mutating error?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
what is sp_pkeys? : Transact sql
Why are aggregate functions called so?
Explain correlated query work?
How many types of relationship are there?
