Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361155 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
What are the set operators in sql?
How to fix oracle error ora-00942: table or view does not exist
What is rowid in sql?
What is basic structure of pl sql?
What are all the common sql functions?
what's the difference between a primary key and a unique key? : Sql dba
What are the three pl sql block types?
How to start oracle sql developer?
Is null operator in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What is the process of debugging?
How do you declare a constant?
What is sql profiling in oracle?
What are the different set operators available in sql?
How do I view tables in mysql?
