Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    15

    Unanswered: HowTo Select firts rows

    Hi,

    I'm looking for a way to get the firts rows of a query, (on IDS 7.3).
    In other words something similar to the TOP command in MS SQL Server.

    For example: "select top 100 * from tablename".

    Does anyone knows Hos to do that ?

    Thanks a lot

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: HowTo Select firts rows

    Originally posted by wzbn
    Hi,

    I'm looking for a way to get the firts rows of a query, (on IDS 7.3).
    In other words something similar to the TOP command in MS SQL Server.

    For example: "select top 100 * from tablename".

    Does anyone knows Hos to do that ?

    Thanks a lot
    Hi,

    Select firts 50 col1, col2 from tablename

    you will have to specify the columns

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: HowTo Select firts rows

    Originally posted by lloydnwo


    Hi,

    Typo error, it should be first


    Select first 50 col1, col2 from tablename

    you will have to specify the columns

Posting Permissions

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