Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367533 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 / kasiraya
SELECT SALARY
FROM
(
SELECT ROW_NUMBER() OVER( ORDER BY SALARY DESC) AS
SL_NO,SALARY
FROM EMP
ORDER BY SALARY DESC
)
WHERE SL_NO=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is indexing done in search engines?
What is the usage of distinct keyword?
What is the primary key?
Can we write ddl statements in functions?
What is sql dialect?
What is nosql db?
What is the advantage of index in sql?
Is sqlite thread safe?
What is sql deadlock?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is the difference between delete and truncate commands?
Is json a nosql?
How to move files from one directory to another in pl sql?
How do you delete data from a table?
What is thread join () in threading?
