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
How sql query is executed?
Is sql easier than java?
What is pl sql in oracle?
What is the file extension for sql database?
What is a heap in sql?
What are hotfixes and patches?
Is oracle sql free?
Does mysql support pl sql?
What does over partition by mean in sql?
What are sql indexes?
What is the sql case statement?
Why use subqueries instead of joins?
What are the types of optimization?
Why primary key is required?
what is the difference between myisam static and myisam dynamic? : Sql dba