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
- 21195 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / sree
select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Informatica settings are available in which file?
How you prepared reports for OLAP?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain sessions. Explain how batches are used to combine executions?
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
How to generate sequence numbers using expression transformation?
What is joiner transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain about cumulative Sum or moving sum?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is joiner change?
What is the difference between a connected look up and unconnected lookup?
How to join three sources using joiner?
