how to find the second highest salary from emp table?
Answer Posted / bhoopendra vishwakarma
select salary max(salary) from emp limit1 offset1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is union and union all keyword in sql?
what are the properties and different types of sub-queries? : Sql dba
Is truncate ddl or dml?
What is autocommit sql?
how to delete an existing column in a table? : Sql dba
What is normalisation and its types?
What is execute immediate?
List the various privileges that a user can grant to another user?
What is on delete restrict?
What are the features of pl sql?
Why is a trigger used?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is number function in sql?
how many ways we can we find the current date using mysql? : Sql dba
How to return an array from java to pl/sql?