Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21746 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
It can be retrieved with a simple subquery.
For example, I create a table sal with id,sal
id sal
-------
11 1000
22 1000
33 1000
44 1000
to retrieve the third column with the same salary
use the below query:
select id,sal from (select id,sal,rownum r from sal)
where r=3;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is a difference between complete, stop and abort?
What is event and what are the tasks related to it?
What is the use of target designer?
What is target load order?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to create the source and target database connections in server manager?
How to extract sap data using informatica? What is abap? What are idocs?
What can we do to improve the performance of informatica aggregator transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
design of staging area?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is incremental aggregation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a pre-defined event and user-defined event?
How to join three sources using joiner?
