how to find the second highest salary from emp table?
- 211 Answers
- 321033 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
How do you explain an index number?
What is sql in oracle?
Which join is like an inner join?
What is clustered and nonclustered index in sql?
what is a view? : Sql dba
How do you modify a trigger?
What is cursor in pl sql with examples?
How can I delete duplicate rows?
Can %notfound return null after a fetch?
Should I use mbr or gpt?
What is transaction control language (tcl)?
What are sql built in functions?
What is pl sql in oracle?
what are the advantages of using stored procedures? : Sql dba
How to Declare Fixed Length String Value In PL SQL
