SELECT TOP 100 from MyTable;

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 / kuldeep raaj sharma

Answer Posted / kuldeep raaj sharma

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the meaning of connection?

965

What are the differences between setmaxrows(int) and setfetchsize(int)?

1065

How to rollback a JDBC transaction?

1096

Give steps to connect to the db using jdbc?

1015

What is jdbc and jpa?

994

java based application for hospital management

3826

Is uri the same as url?

898

How can you make a connection?

986

What is a jdbc connection pool?

934

How to check jdbc connection in linux?

1031

What are the differences between execute, executequery, and executeupdate?

953

What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?

990

What is metadata in jdbc?

998

What are the main steps in java to make JDBC connectivity?

1008

How to check jdbc driver version in sql server?

968