Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368913 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 / jithu
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
Do foreign keys improve performance?
What is an escape character in sql?
What are the three forms of normalization?
What is the limitation on the block size of pl/sql?
What is over () in sql?
Are views faster than queries?
What is difference between mysql and postgresql?
Why do we use subquery?
how would you enter characters as hex numbers? : Sql dba
Explain constraints in sql?
Why is theta join required?
Can we call a function containing dml statements in a select query?
What are the main features of cursor?
what is a trigger in mysql? : Sql dba
What is crud diagram?
