Post reply

Numbering the Result Set - Like Rownum(ORACLE)

  • July 18, 2003 at 7:03 am

    #82286

    I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM (Oracle) in SQL Server. Is it possible in SQL Server 2000 to number the result set in a sequence?

    Thank You

    Anil K Godumagadda

  • July 18, 2003 at 1:54 pm

    #466108

    There is no equivalent to ROWNUM in SQL. Take a look at this:

    http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

  • July 21, 2003 at 12:23 am

    #466143

    Hi Anil,

    quote:

    I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM (Oracle) in SQL Server. Is it possible in SQL Server 2000 to number the result set in a sequence?

    same topic as in a different category. Crosspost?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply