Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7630 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you have more than one content canvas view attached with a window ?
What are the major difference between truncate and delete?
How to start your 10g xe server?
What are the different types of failures that occur in Oracle database?
How to use "while" statements in oracle?
What are the attributes that are found in a cursor?
How to do a full database export?
How to pass a parameter to a cursor in oracle?
What is the scope of a local variable?
What is a proxy class?
various types of hints and their usage
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to define a data field as not null?
Why is oracle so popular?
How does one get the view definition of fixed views/tables?
