query should be prepare like this select * from tab

i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?

Question Posted / dmk.java@gmail.com

Answer Posted / dmk.java@gmail.com

query should be prepare like this

select * from tab_name where rownum <= 100

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is device controller?

1068

What is the limitation of PreparedStatement and how to overcome it?

1148

What is odbc jdbc?

1008

What is a rollback in jdbc?

946

Is jdbc a middleware?

956

Why is jdbc used?

951

What is connection data?

918

Why would you use setautocommit(false) in jdbc?

1209

What is new in JDBC 2.0?

1026

How to know howmuch data is truncated?

2371

What does jdbc stand for?

944

What is the function of setautocommit?

1240

Which Java and java.sql data types map to my specific database types?

1079

How do I set properties for a JDBC driver and where are the properties stored?

966

Discuss the significances of jdbc.

924