Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367463 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 difference between undefined value and null value? : Sql dba
what is a database transaction? : Sql dba
What is gpt format?
What is a table in a database?
What program will open a mdb file?
How many types of triggers exist in pl/sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the unique index?
Explain the the delete statements in sql?
Is sql scripting language?
What are the two types of cursors in pl sql?
What is consistency?
Explain character-manipulation functions?
What is a record in a database?
How can you select unique records from a table?
