how to find the second highest salary from emp table?
Answer Posted / jitendra kumar
select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain the delete statements in sql
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How much does sqlite cost?
Define overloaded procedure?
Why do we use partitions in sql?
Explain the update statement in sql
What do you mean by query optimization?
How many row comparison operators are used while working with a subquery?
Why we use triggers in mysql?
What is not null in sql?
How do I sort a table in sql?
How many types of index are there?
Is left join same as join?
differentiate between float and double. : Sql dba
Does access use sql?