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
- 21196 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
How does a sorter cache works?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is meant by incremental aggregation?
What is the commit type if you have a transaction control transformation in the mapping?
What is the benefit of partitioning a session?
What is olap (on-line analytical processing?
what is the -ve test case in your project.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What do you mean by blocking transformation?
What is meant by query override?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is deployment group?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
