Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Select Statement: Limiting Number Of Rows

    how can i do to limit the number
    of rows retrieved in a select statement?

    For example in sybase there is "set rowcount" command.

    Thank you.

  2. #2
    Join Date
    Jul 2001
    Bangalore, India
    "select * from table1 fetch first n rows"

  3. #3
    Join Date
    Dec 2003
    Thanks for your reply.

    Your code works perfectly.
    But I want ask you another question:

    I have a java web application that retrives a large amount of data that are display like lists and charts.
    I want to know if there's a possibility of managing this data little by little
    without load all in session.
    Now my list loads the entire resultSet in session and display only
    20 rows at time using back and forward utility, but the memory space grows too much.

    Can you help me?
    Thanks Stenx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts