I have the following table -

Name Enrolment# File#
x 422 011
y 421 022
z 444 023
a 345 024


I have to produce the following table -

S.No Name Enrolment# File#
1 a 345 024
2 y 421 022
3 x 422 021
4 z 444 023


Could someone please help me out with the SQL query to do the
operation above? I know how to sort by enrolment# but how do I produce
the first column of the target table?

Thanks in Advance.

- P.