Get table's row number in ms sqlserver

Introduction:

             I will explain here how to get  row number of table using sql query.

Explanation:

             If you want to get row number for particular row of table or row numbers of table you can use ROW_NUMBER () key word here i used to show query for getting row number of brcon_tbl where brcate_ID='3'.

SELECT ROW_NUMBER()OVER (ORDER BY brcon_ID) AS Row,brcon_ID  FROM brcon_tbl  WHERE brcate_ID ='3'