Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368102 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
What is the current version of sql?
What do you mean by dbms? What are its different types?
How do you use a while loop in pl sql?
What is a design view?
What is the difference between inner join and outer join?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the purpose of the sql select top clause?
What is the difference between alter trigger and drop trigger statements?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Can a foreign key be a duplicate?
define sql insert statement ? : Sql dba
what is 'mysqldump'? : Sql dba
Explain the uses of database trigger.
What is numeric function sql?
What does rownum mean in sql?
