Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Wink Unanswered: how to fetch subset of records

    Dev Enviro: Apache, PHP, MySQL, AS400 via ODBC, Adodb

    I searched the thread but unable to find answer for this question.

    What is the correct SQL string to get 10 rows from a table in AS400?

    In MySQL can use LIMIT, or use wrapper Adodb SelectLimit function. But sometimes I need to query a table using the ODBC connection to the AS400 without using the wrapper.

    Thanks for any help.

  2. #2
    Join Date
    Aug 2003
    ...where ROWNUM < 11

Posting Permissions

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