Results 1 to 3 of 3

Thread: set rowcount?

  1. #1
    Join Date
    Jun 2004
    Posts
    24

    Unanswered: set rowcount?

    I can use the SQL Statement "set rowcount 100" to set the rowcount, how can I do that in DB2?
    Thanks very much~

  2. #2
    Join Date
    May 2002
    Posts
    30
    Select * From Table_a Fetch First 100 Rows Only

  3. #3
    Join Date
    Jun 2004
    Posts
    24
    Quote Originally Posted by soundharya_s
    Select * From Table_a Fetch First 100 Rows Only
    Thanks very much
    But can I seprate it into two statements like SQL server:
    set rowcount 100
    select * from table_a

Posting Permissions

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