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 dbrm? What it contains?

906

is it compulsory commitment control in journal?

2225

What is dbrm library?

794

How do you concatenate the firstname and lastname from emp table to give a complete name?

810

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

821

What is load utility in db2?

893

Explain the function of data manager.

810

Where do you specify them?

880

What is lock escalation in db2?

778

What is phantom read in db2?

833

Highlight all the advantages that are attached to a package.

883

My sql statement select avg(salary) from emp yields inaccurate results. Why?

858

what is the responsibility of the construction superintendent

1883

What is view db2?

846

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

855