SELECT *, (SELECT COUNT(*) FROM Mas_Company e2 WHERE e2.Company_Code <= e.Company_Code) AS 'rownumber' , Mas_Company.*, Company_Code AS Expr1, Company_Name AS Expr2, Company_SName AS Expr3, Company_Add1 AS Expr4, Company_Add2 AS Expr5, Company_City AS Expr6, Company_Pincode AS Expr7, Company_ph_no AS Expr8, Company_Active_Flag AS Expr9 FROM Mas_Company e