how to find the second highest salary from emp table?
- 211 Answers
- 321290 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 / anuj maheshwari
select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));
| Is This Answer Correct ? | 34 Yes | 5 No |
Post New Answer View All Answers
how to load data files into tables with 'mysqlimport'? : Sql dba
Difference between table function and pipelined function?
Can we alter stored procedure?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is meant by truncate in sql?
What will you get by the cursor attribute sql%found?
What are triggers and its uses?
Why is normalization important?
What is mutating error in pl sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is a delimiter in sas?
Is like operator in sql case sensitive?
Define overloaded procedure?
How you improve the performance of sql*loader? : aql loader
Explain spool.
