Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 20991 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / suraj kedia
There are 3 ways to find out the nth highest salary in a
given table (e.g. emp) as below;
1) select distinct sal from emp e1 where &n=(select count
distinct sal from emp e2 where e1.sal <=e2.sal);
2) select empno,enaame,sal,deptno,rank () over (order by sal
desc) as ra from emp where ra=&n;
3) select empno,enaame,sal,deptno,dense_rank () over (order
by sal desc) as ra from emp where ra=&n;
All the above methods are tried n tested....it works
successfully.
What is a Cursor.
When a query is executed in oracle, a result set is produced
and stored in the memory. Oracle allows the programmer to
access this result set in the memory through cursors.
Why use a cursor?
Many times, when a query returns more than one row as a
result, we might want to go through each row and process the
data in different way for them. Cursor is handy here.
Types of cursors:
Oracle PL/SQL declares a cursor implicitly for all queries
and DML statements (including queries that return only one
row). But in most of the cases we don’t use these cursors
for queries that return one row. Based on this, there are 2
types of cursors
1. Explicit cursor
2. Implicit cursor
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
How can we improve session performance in aggregator transformation?
What is meant by active and passive transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
waht type of interface is used for testing the data in informatica
Where is metadata stored?
How can we store previous session logs?
What do you understand by SOA of Informatica?
What is the session task and command task?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is a node in Informatica?
how to create user defined function (udf) in informatica
How to improve the performance of a session using sorter transformation?
design of staging area?
Plz can any one say me how to get the informatica certification materials and dumps
