how to find the second highest salary from emp table?
Answer Posted / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to create a table index in mysql? : Sql dba
Does sql*plus have a pl/sql engine?
What is the max nvarchar size?
what are ddl statements in mysql? : Sql dba
Can we call dml statement in function?
How to place comments in pl/sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
What is java sql package?
explain the delete statements in sql
Is sql open source?
What are different types of indexes?
How can get second highest salary in sql?
How do I start sql profiler?
What is scalar function?