how to find the second highest salary from emp table?
- 211 Answers
- 322010 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 / gurvinder
select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does over partition by mean in sql?
What is normalization in sql?
What is the difference between sql, mysql and sql server?
What are the events on which a database trigger can be based?
How can get second highest salary in sql?
How would you convert date into julian date format?
Does user triggers have entry for trigger with compilation errors?
What is difference between group by and partition by?
What is the example of procedure?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What does inner join mean?
What is embedded sql with example?
how is myisam table stored? : Sql dba
What is synonyms?
how to create a test table in your mysql server? : Sql dba
