Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373316 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
Why we use joins in sql?
Explain architecture of sql server notification services?
Whis is not false in primary key?
What is the best sql course?
What are the most important characteristics of pl/sql?
What are stored procedures used for?
What are views in sql?
What are the disadvantages of not performing database normalization?
What is query syntax?
how to calculate the difference between two dates? : Sql dba
What are the types of index in sql?
What are local and global Indexes and where they are useful.
What is the usage of when clause in trigger?
What are the basic sql commands?
What jobs use sql?
