hi all, suppose 4 emp geting same sal as 4000... select * from emp wher

In a table, 4 person having same salary. How to get Third
person record only?

Question Posted / pooja

Answer Posted / pooja

hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3

Is This Answer Correct ?

0 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Explain informatica architecture - version 8 / 9

1152

What are the new features of Power Center 5.0?

1846

What is data transformation manager process?

1221

What are the transformations that are not supported in mapplet?

1084

list out all the transformations which use cache?

1239

What are session parameters ? How do you set them?

1899

How would you copy the content of one repository to another repository?

1058

How do you set a varible in incremental aggregation

1944

How do you load only null records into target?

1251

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1112

what is the difference between informatica6.1 and infomatica7.1

2361

How do you use reject loader.

2651

What are the settings that you use to configure the joiner transformation?

1102

What is decode in informatica?

1252

Explain what transformation and how many are there in informatica?

1023