Use any one column name and its value of the 10th row to fetch the 10th..

I want to fetch the 10th row of a table which has been
changed.How can I do it without going thru all the rows.

Question Posted / nadeem

5 Answers
10698 Views
I also Faced
E-Mail Answers

Answer Posted / nadeem

Use any one column name and its value of the 10th row to
fetch the 10th..for eg
select * from Table where deptno = 0010(any column name and
its value of 10 row)

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is it possible using max on a char column?

1122

What is bufferpool in db2?

1026

Mention data types used in db2 ?

1140

What is the maximum No of rows per page?

1052

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1036

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1170

What is the function of logging in the db2 database?

1102

Why do we need reorg in db2?

968

What is deadlock in db2?

1050

How to take backup of table in db2?

1054

Explain the function done by data manager?

1258

What is the use of predicate?

1024

What is precompiler in db2?

996

What is db2 purescale?

979

What is db2 and what is the use of db2 optimizer?

1032