select * from(select <table_name>.*,rownum rn from <Table

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

Question Posted / srinivas

Answer Posted / srinivas

select * from(select <table_name>.*,rownum rn from <Table_name>) where rn between 100 and 120

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

646

what are the advantages of sql ? : Sql dba

550

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

722

how to use 'mysql' to run sql statements? : Sql dba

539

Where not exists in sql?

503

What is embedded sql with example?

546

Can you have more than one key in a database?

509

What is auto increment feature in sql?

623

Why do we need cursor in pl sql?

651

Explain the significance of the & and && operators in pl sql.

574

How does a trigger work?

538

How many types of keys are there in sql?

556

State some properties of relational databases?

584

what are the security recommendations while using mysql? : Sql dba

581

Can we use the cursor's to create the collection in PL/SQL?

522