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
10564 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

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4229

What is db2 catalog database?

995

What is db2 command?

980

Who uses db2?

988

Explain about dbrm.

997

What is performance tuning db2?

1018

What is ibm db2 used for?

1016

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1056

Name the various locking levels available?

1049

What's The Percentage Free Space ?

1170

What is syscat in db2?

958

What is the role of the data page in the db2 database?

983

How to retrieve rows from a db2 table in embedded sql?

1346

Why cursor is used in db2?

993

Define sqlca.

1062