how to find the second highest salary from emp table?
Answer Posted / sachin verma
select sal from emp
where rownum=2
order sal by Desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
write an sql query to find names of employee start with 'a'? : Sql dba
Does sql use python?
What is difference between inner join and self join?
Can we use ddl statements in stored procedure sql server?
What are %type and %rowtype for?
How many indexes can be created on a table in sql?
How you improve the performance of sql*loader? : aql loader
what is the difference between join and union? : Sql dba
explain normalization concept? : Sql dba
Difference between truncate, delete and drop commands?
How to Execute a Package in PL/SQL.?
What are commit, rollback, and savepoint?
What is lookup table in sql?
What are the different type of joins in sql?
What is sorting in sql?