How to get the selected rows with row number as column?

See more:

C#

SQL

hi to all,

i would like to know whether there is way to get selected rows with their row number as column

for example

select job_desc from jobs where max_sal>20;

it will result 20 rows

now i would like get the rows along with their row number as column

such as

rowN0            job_desc
-----              ---------  
1                 manager
2                 sales man
3                 programmer
.................. 

is it possible in SQL?

if not, please tell me the its equivalent C# code.