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

What is oracle sql called?

979

In a distributed database system, can we execute two queries simultaneously?

1156

Explain alias in sql?

1095

Which tcp/ip port does sql server run?

1070

What is a database trigger?

1138

explain the difference between bool, tinyint and bit. : Sql dba

1063

Explain foreign key in sql?

1084

Is full outer join same as cross join?

1018

how is exception handling handled in mysql? : Sql dba

1132

Write a sql select query that only returns each name only once from a table?

1078

what is commit? : Sql dba

1127

Does view contain data?

1084

How bulk collect improves performance?

1055

Does sql*plus also have a pl/sql engine?

1131

What is an implicit commit?

1104