I am sorry guys ...My table has single column but has 7 crore rows.Column type is varchar. As that column has random data I cannot give row # after sorting. I want to gve row # as they are in table and then do data manipulation.
If you need to track the order that the rows were inserted to the table then you'll need an identity column on the table or a timestamp of some sort. Of course if multiple rows are added in a single statement then the order of those will be randomly assigned. If you have no data in the table that can differentiate the order they were inserted then there is no way to present it in the order it was inserted.