1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Post New Answer

More SQL PLSQL Interview Questions

How do I view an execution plan in sql?

0 Answers  

What is function and procedure in pl sql?

0 Answers  

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

When the mutating error will comes? and how it will be resolved?

2 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,




How do you update f as m and m as f from the below table testtable?

0 Answers  

What is insert command in sql?

0 Answers  

What is a Mapplet?

0 Answers   Informatica,

What is the use of index in sql?

0 Answers  

What is the current version of sql?

0 Answers  

What is dense_rank in sql?

0 Answers  

What is sql*loader?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories