how to find the second highest salary from emp table?
- 211 Answers
- 322014 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 / mona thakur
SELECT *
FROM emp
WHERE salary < (
SELECT max( salary )
FROM emp )
ORDER BY salary DESC
LIMIT 1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you skip header records while loading? : aql loader
What is the max nvarchar size?
Explain constraints in sql?
How many types of keys are there in sql?
Can delete statement be rollbacked?
Does db2 use sql?
What packages are available to pl/sql developers?
Does oracle use sql?
What are operators available in sql?
Where do we use pl sql?
What is the meaning of disabling a trigger?
What is the difference between a primary key and a unique key?
What are the set operators in sql?
What is the difference between microsoft sql and mysql?
What is the difference between syntax error and runtime error?
