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 jdbc explain?

978

How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

1124

Why hibernate is better than jdbc?

979

How can I determine the isolation levels supported by my DBMS?

1040

What is an encrypted internet connection?

985

Is there another way of dealing with the result set that could execute faster?

1048

What are different parts of a url?

1051

Is jdbc object oriented?

995

How can we store the file in the oracle database?

986

How many ways that we can view a result set?

1059

What does adapter class provide?

999

What causes no suitable driver error?

1015

Explain what should be done when a SQL exception is raised?

1029

Which database is used for java?

1006

What are the conditions applies to varchar variable, when using in procedures?

2216