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
- 20857 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / venky
select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is status code in informatica?
Enterprise data warehouse your projects phase by phase explain?
What is a sorter transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What do mean by local and global repository?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the prerequisite tasks to achieve the session partition?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is powercenter on grid?
On which transformations you created partitions in your project?
Differentiate between sessions and batches?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain pmcmd command usage in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the surrogate key?
