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 role in db2?

1110

What are the uses of db2 optimizer?

1299

What is db2 purescale?

1011

Give the name of some fields form sqlca.

1090

How does coalesce work?

1032

Explain about mirror activator disk mirroring?

1016

Can we delete records from view?

970

Describe major components of db2?

1096

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1087

What is db2 and what is the use of db2 optimizer?

1070

Are views updateable?

1166

How do we specify index to include or not during bind process.

2131

How do I create a view in db2?

1027

How is deadlock resolved?

1152

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1275