aspose file tools*
The moose likes JDBC and the fly likes Regd JDBS Statement... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regd JDBS Statement..." Watch "Regd JDBS Statement..." New topic
Author

Regd JDBS Statement...

senthil nathan
Greenhorn

Joined: Jun 14, 2002
Posts: 17
Hi,
I have a query which returns 10,000 rows and it takes lot of time to return.so is there any way in java while calling statement.executeQuery that i can mention get only 60 rows...
Thanks.
Senthil
Pat Wallwork
Ranch Hand

Joined: Sep 23, 2001
Posts: 72
In your SQL statement just say limit 60

this limits the results returned to the first 60 for your query
-Pat
senthil nathan
Greenhorn

Joined: Jun 14, 2002
Posts: 17
I'm working in DB2 database...this is not possible....
Any other suggestion...
Thanks
Senthil
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regd JDBS Statement...