Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367903 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 / subrat
SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FROM EMP)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cte sql?
What is the purpose of the partition table?
Do we need to rebuild index after truncate?
how do you login to mysql using unix shell? : Sql dba
Does a user_objects view have an entry for a trigger?
What is sqlca in db2?
Which are the different types of indexes in sql?
What are system versioned tables?
Why join is faster than subquery?
How to call shell script from pl sql procedure?
Give the order of sql select?
What is sql dialect?
Where is pl sql used?
What is meant by <> in sql?
How can we implement rollback or commit statement in a trigger?
