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 are the various isolation levels possible?

1048

Mention data types used in db2 ?

1105

What is the reason behind not using select * in embedded sql programs?

1044

How can you quickly find out the # of rows updated after an update statement?

985

What is a db2 collection?

981

What is a dbrm in db2?

969

What is dpf in db2?

1048

Explain the contention situations caused by locks?

1012

Discuss about db2 bind?

1048

Explain in brief how does db2 determine what lock-size to use?

959

Explain packages.

1055

What is the advantage in De-normalizing tables in DB2?

1114

What is db2 catalog database?

987

What is load utility in db2?

1130

List out the three types of page locks that can be held.

1091