Does SQL Server support row numbers like Oracle does?

A. No - row numbering is contrary to relational sets (which is what rdbms's running SQL are all about). It is not an ANSI standard. Microsoft have not implemented anything like it.

If you need to use row numbers you should look at your application and see if it is really appropriate to a SQL database.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.