how to find the second highest salary from emp table?

Answer Posted / atheeq

select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of views in sql?

533


What is structural independence and why is it important?

542


How do I find duplicates in a single column in sql?

526


What is serial sql?

520


what is a control file ? : Sql dba

569






Are pl sql variables case sensitive?

590


What is a variable in sql?

509


How to avoid duplicate records in a query?

575


What is nvl?

607


What is the use of function in sql?

525


what is meant by urlencode and urldocode? : Sql dba

592


what is online transaction processing (oltp)? : Sql dba

520


what is the difference between truncate and delete statement? : Transact sql

536


What is exit statement?

537


What is auto increment?

576