how to find the second highest salary from emp table?
- 211 Answers
- 321388 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 / vikas naik
select max(sal) from employee where sal not in(select
max(sal) from employee);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different tcl commands in sql?
What is the use of %rowtype?
What types of commands can be executed in sql*plus?
what are date and time functions in mysql? : Sql dba
How do I start sql profiler?
How to execute a stored procedure?
Which nosql database is best?
What are different sql data types?
What is difference between sql and excel?
How does cross join work in sql?
What does fetching a cursor do?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Is left join same as inner join?
Which one is better subquery or joins?
Does sql full backup truncate logs?
