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

How does a custom RowSetReader get called from a CachedRowSet?

1082

How many types of jdbc drivers are available?

936

How to use JDBC API to call Stored Procedures?

1016

What is resultset?

995

What driver should I use for scalable Oracle JDBC applications?

980

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

1020

Why “no suitable driver” error occurs?

1085

Which package is used for jdbc application?

977

What are the three basic components of the odbc architecture?

926

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

1145

Name the method, which is used to prepare a callablestatement.

910

What is jdbc resultsetmetadata interface?

962

How can I connect mysql or oracle with java?

966

How to move the cursor in scrollable resultset ?

1035

What is difference between statement and preparedstatement in jdbc?

910