Use any one column name and its value of the 10th row to fetch the 10th..

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 / nadeem

5 Answers
10805 Views
I also Faced
E-Mail Answers

Answer Posted / nadeem

Use any one column name and its value of the 10th row to
fetch the 10th..for eg
select * from Table where deptno = 0010(any column name and
its value of 10 row)

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2057

Explain packages.

1119

What is the use of predicate?

1055

What is database alias db2?

1138

Before you give the explain statement, what are the prerogatives?

1058

How to run db2 command in windows?

1207

what are bind concepts in db2 cobol?

1108

What is sqlca?

1089

How to check sequence on a table in db2?

1073

What does runstats do in db2?

1133

What r the comman abends in db2, jcl and cobol???????

2272

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 ?...

4320

Are view updateable?

1055

What is meant by dclgen?

1122

Which component is responsible for processing sql statements and selecting access paths?

1143