select * from table where rownum<=30 minus select * from table whe

how will you get 21 to 30 record from 50 records?

Question Posted / srikanth

Answer Posted / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can we improve session performance in aggregator transformation?

1092

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2021

Explain scd type 3 through mapping.

960

What are Dimensional table?

1044

Differences between connected and unconnected lookup?

1201

What are the different lookup cache(s)?

1094

What is the difference between Active and Passive transformation?

1133

is it possible to index the data in cache of lkp transformation ?

2016

What is standalone command task?

1305

Under which circumstances, informatica server creates reject files?

1073

What is the function of union transformation?

1109

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2432

Explain pmcmd command usage in informatica

1105

Explain the features of connected and unconnected lookup.

917

What are batches?

1076