select * from tabblename where rownum<101

how can we retrieve the 100 records of the file ?

Question Posted / anjireddy vintha

Answer Posted / anjireddy vintha

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the function of logging in the db2 database?

1066

What is sqlca?

998

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

1040

Explain packages.

1055

What is the difference between spufi and qmf?

1052

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

1032

What is the use of dclgen in db2?

1010

What is db2 instance?

1015

What do you mean by cursor?

942

How does a cursor work?

926

What do you mean by commit and rollback?

972

What is commit in db2?

995

What is declare cursor?

1039

What is the maximum size of varchar data type in db2?

1063

How is a typical db2 batch pgm executed?

1106