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
What are the types of views in sql?
What is structural independence and why is it important?
How do I find duplicates in a single column in sql?
What is serial sql?
what is a control file ? : Sql dba
Are pl sql variables case sensitive?
What is a variable in sql?
How to avoid duplicate records in a query?
What is nvl?
What is the use of function in sql?
what is meant by urlencode and urldocode? : Sql dba
what is online transaction processing (oltp)? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
What is exit statement?
What is auto increment?