Adding Row Number to SQL SELECT result

 Query:

select  row_number() over(order by mrnno) from MRNselfMaterialDetails

here
 row_number()-------------is Built in function
over(order by mrnno)-------------is a function 
order by------------------------------key word
mrnno---------------------------------Column Name
MRNselfMaterialDetails-----------Table Name


For More References watch

1) http://www.openwinforms.com/row_number_to_sql_select.html

2) http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103432