how to find the second highest salary from emp table?
- 211 Answers
- 321294 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 / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
| Is This Answer Correct ? | 1090 Yes | 131 No |
Post New Answer View All Answers
How does sql profiler work?
What is a left join?
What are types of joins?
what are local and global variables and their differences? : Sql dba
Which join condition can be specified using on clause?
Why we use triggers in mysql?
What is pivot query?
what is the use of friend function? : Sql dba
What is a temporal table?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How many indexes can be created on a table in sql?
What do you mean by rowid?
Can we insert in sql function?
How do I view tables in sql developer?
Does varchar need length?
