Home Forums SQL Server 7,2000 T-SQL Numbering the Result Set - Like Rownum(ORACLE) RE: Numbering the Result Set - Like Rownum(ORACLE)

  • 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]