Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373035 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 disk partitions should I have?
What are system versioned tables?
What are the ddl commands?
What is the difference between joins?
Explain unique key in sql.
What does fetching a cursor do?
What is natural join in sql?
What is numeric function sql?
what are the properties and different types of sub-queries? : Sql dba
How delete all records from table in sql?
What is a data definition language?
Is hadoop a nosql?
Which is faster count (*) or count 1?
Mention what pl/sql package consists of?
Why procedure is used in sql?
