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 are commit, rollback, and savepoint?

995

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

Why are aggregate functions called so?

946

Does pl/sql support create command?

1110

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

What is insert command in sql?

1131

What is procedure and function in sql?

1001

Does sql view stored data?

959

How to handle bulk data?

1310

Can we use ddl commands in pl sql?

1162

What are the differences between in and exists clause?

1111

Can a varchar be a primary key?

1009

What are the string functions in sql?

975

How delete a row in sql?

995

How do I filter in sql profiler?

994