Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28771 Views
- I also Faced
- E-Mail Answers
Answer Posted / senorita
select ename,salary from (select rownum,ename,salary from
emp
order by desc) where rownum=2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the uses of a database trigger?
How many clustered indexes can you have?
Enlist the characteristics of pl/sql?
How do you declare a constant?
What are the two different parts of the pl/sql packages?
Why join is faster than subquery?
How do you break a loop in pl sql?
How to sort the rows in sql.
Is sql low level language?
Is sql a backend?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How do I delete a trigger?
Can you have more than one key in a database?
Why plvtab is considered as the easiest way to access the pl/sql table?
What does closing a cursor do?
