select level from dual connect by level<=150 minus select from dual con

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / manjunath

Answer Posted / manjunath

select level from dual connect by level<=150
minus select from dual connect by level<=120;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I quit sql?

897

What are the different types of tables in sql?

929

What are the subsets of sql?

1037

how do you control the max size of a heap table? : Sql dba

921

What is pivot in sql?

871

What is memory optimized table?

984

What is parameter substitution in sql?

976

What is sql constant?

943

What's the procedure?

865

How does sql store data?

866

How do you update a sql procedure?

970

Is sql better than access?

961

How do you use a while loop in pl sql?

940

Can we join two tables without common column?

929

Why is partition used in sql?

1050