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

5 Answers
10767 Views
I also Faced
E-Mail Answers

Answer Posted / satish.klnm

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

Is This Answer Correct ?

0 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database reorganization?

1125

List out the buffer pools in db2

1073

How to fetch the last row from the table in SQL (db2)?

1653

What is ibm db2 client?

939

What is the difference between db2 and oracle?

1131

How to connect to db2 database from windows command line?

1065

Are view updateable?

1043

How to find primary key of a table in db2?

1065

What is scrollable cursor in db2?

1055

How can the duplicate values be eliminated from db2 select?

1106

How do I connect my db2 database to ibm?

1050

Are views updateable?

1155

What is db2 command?

1035

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2097

How do you stop a db2 database in linux?

1012