how to find the second highest salary from emp table?
- 211 Answers
- 322223 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 / kiran
select max(sal) from emp where sal in(select sal from emp
where sal<>(select max(sal) from emp))
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we optimize a sql query?
What is online transaction processing (oltp)?
What is oracle pl sql developer?
Is subquery faster than join?
What is the function that is used to transfer a pl/sql table log to a database table?
What is t-sql? : Transact sql
Which is better stored procedure or query?
What is set serveroutput on?
What is prepared statement in sql?
What is normalization in a database?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
what are date and time data types in mysql? : Sql dba
What are the basic sql commands?
how to use myisamchk to check or repair myisam tables? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
