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

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

Question Posted / bsanjib

Answers were Sorted based on User's Feedback

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

Answer / intelligent

select * from emp where rownum>101 and rownum<121

Is This Answer Correct ?

2 Yes

18 No

More SQL PLSQL Interview Questions

What is data manipulation language?

What is the result, when NULL is compared with NULL?

Write a procedure to return the month and the number of developers joined in each month (cursor )

how can create data base link for tow servers (scott schema) give examples plz

what is uncommittable transactions? : Transact sql

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

Is trigger a stored procedure?

Why do we need sharding?

what is sql in mysql? : Sql dba

What are the limitations of sql express?

what is a constraint? Tell me about its various levels. : Sql dba

How much ram can sql express use?

For more SQL PLSQL Interview Questions Click Here