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.

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

Define check constraint.

859


Are views updateable?

852


What are the 2 sqlcodes that are returned?

893


Mention the definition of cobol in varchar field.

921


What is a db2 table?

790


Is db2 a database?

764


What is the use of predicate?

810


Give a brief description of db2 isolation levels?

813


How and when does the db2 enforces the unique key?

866


Why db2 is called db2?

797


What's The Percentage Free Space ?

992


What does runstats do in db2?

792


What is lock escalation in db2?

793


How to view db2 table structure?

818


What does sqlcabc has?

814