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 resultsetmetadata?

838

What is difference between jdbc and odbc?

943

What is connection data?

855

How can you know about drivers and database information ?

948

What is jdbc databasemetadata interface?

993

Differentiate between a statement and a preparedstatement.

930

How to move the cursor in scrollable resultset ?

985

What is jdbc? Describe the steps needed to execute a sql query using jdbc.

847

What does the jdbc resultsetmetadata interface?

887

What is a statement?

960

What are the different types of classes in the api component?

916

What are the common tasks of JDBC?

933

Explain how data flows from view to db and reverse

1985

When does the result for an sql statement return null?

856

Why do we need jdbc api?

909