• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regd JDBS Statement...

 
senthil nathan
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In your SQL statement just say limit 60

this limits the results returned to the first 60 for your query
-Pat
 
senthil nathan
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm working in DB2 database...this is not possible....
Any other suggestion...
Thanks
Senthil
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic