Select Like following
SELECT custid, custname, ROW_NUMBER() OVER(ORDER BY custid asc) AS ‘Row Number’ from members
will list row number serially
abhilash,abhilash nair,abhilash s,kothamangalam,inchoor,malayalam,linux,kerala,kochi,cochin,ernakulam,india,redhat,ubuntu,mssql server,asp,asp.net,web hosting,web development,wordpress,joomla,cpanel,plesk