Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361228 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 / jat16may
SELECT MAX(SALARY) FROM TABLENAME WHERE SALARY<(SELECT
MAX(SALARY) FROM TABLE NAME
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are different clauses used in sql?
How many functions are there in sql?
What are the types of index in sql?
Explain the the update statement in sql?
How do you clear the screen in sql?
How many sectors are in a partition?
Does mysql_real_escape_string prevent sql injection?
How does cross join work in sql?
What's the difference between a primary key and a clustered index?
What is data modelling in sql?
Show the two pl/sql cursor exceptions.
what is 'mysqlimport'? : Sql dba
What is difference between mysql and postgresql?
What is dynamic sql in pl sql?
What is sql partition function?
