select * from ( select ROW_NUMBER() over (order by tablename.columnnam

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

Question Posted / arif hussain

Answer Posted / arif hussain

select * from (
select ROW_NUMBER() over (order by tablename.columnname)as ronno,* from tablename )x
where ronno between 100 and 120

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which language is used in sql?

520

What does t sql mean?

536

How do I run a sql query?

532

How to create a menu in sqlplus or pl/sql?

613

What is the mutating table and constraining table?

561

Explain spool.

691

what is rollback? : Sql dba

595

How many types of cursors are available in pl/sql?

586

How to run sql statements with oracle sql developer?

625

How does join work in sql?

556

Explain about various levels of constraint.

525

What is clustered index sql?

506

when MSQL8.0 is in market

1602

How do I debug a stored procedure?

631

what are the disadvantages of mysql? : Sql dba

574