exec sql select * from table222 where count(*)

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 / satish.klnm

Answer Posted / satish.klnm

exec sql
select * from table222 where count(*) > 9
end-exec.

Is This Answer Correct ?

0 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is meant by explain?

1194

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1157

Give a brief description of db2 isolation levels?

1138

What is null indicator in cobol db2?

1108

What kind of database is db2?

1081

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1288

What do you mean by storage group (stogroup)?

1079

How do you select a row using indexes in db2?

1175

What is db2 bind process?

1289

What are host variables in db2?

1121

What is db2? Explain.

1109

What is runstats and reorg in db2?

1357

Explain about rct in db2?

1161

What is netezza database?

1080

What are the full forms of spufi and dclgen and why are they used?

1136