Results 1 to 1 of 1

Thread: LIMIT or TOP function

  1. 08-25-2004, 02:34 PM #1
    ricgre
    ricgre is offline Registered User
    Join Date
    Aug 2004
    Location
    Wisconsin
    Posts
    7

    LIMIT or TOP function

    I am new to DB2. Does it have a LIMIT or TOP function as uesed in MYSQL or ACCESS. I want to show only the top or bottom 5 records of a query. I know I could state a .cacheSize on the recordset if needed but thought there may be a better way through the SQL statement itself. I tried "Fetch First 5 Rows Only" with no sucess.
    Last edited by ricgre; 08-27-2004 at 11:41 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules