I need to enumerate the resultset rows of a select.

Does sql server has a mechanism like rownum in Oracle?

there are 4 int columns in select

Report this post to a moderator

I discussed this at:
http://vyaskn.tripod.com/ oracle_sq...equivalents.htm

See if that helps!
--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/


"Leonardo" <leonardo@tqi.com.br> wrote in message
news:OzVT2fXlCHA.1516@tkmsftngp04...
> I need to enumerate the resultset rows of a select.
>
> Does sql server has a mechanism like rownum in Oracle?
>
> there are 4 int columns in select
>
>
>

Report this post to a moderator