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

What if the source is a flat-file?

590

What happens when a session fails and you click on recover?

657

Where do we use mapping variables in informatica?

613

What are the advantages of using informatica as an etl tool over teradata?

567

What does command task mean?

610

What is the benefit of session partitioning?

595

Enterprise data warehouse your projects phase by phase explain?

1464

what is the hint? how to use it to reduce the query processing in program?

6303

What is union transformation?

575

define galaxy repository in informatica

1726

What is informatica powercenter repository?

711

Please let me know how to make encryption and decryption with example?

1467

How might you approve all mappings in the archive all the while?

602

What are active and passive transformations?

652

Explain the pipeline partition with real time example?

654