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

DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?

914

What are the common JDBC problems that you got and how do you solved them?

2386

How do you determine the sensitivity of the ResultSet object?

921

How many ways can you update a result set?

957

How vendor Naming registry supports JNDI?

2125

What is the jdbc rowset?

944

What is the meaning of connection?

907

Can we have foreign key reference to a non primary key column ?

909

What do you mean by database connection pooling?

895

What is a jdbctemplate?

882

What is addbatch jdbc?

952

What is jdbc url for mysql?

984

What is the function of setautocommit?

1148

What is the purpose of jdbc?

983

What is the use of getGeneratedKeys() method in Statement?

961