Adding a column with row numbers to the sql Table

THE SQL Code is as follows for without column No field:

SELECT ALSubject FROM Subject_Table


SUBJECTS
Accountancy
Applied Maths
Buniness Studies
Economics
Statistics
Zoology


*********************************************************
The code sql code with adding a column
method:-1
SELECT Row_Number() OVER (order by ALSubject asc) as ID,t.ALSubject As Name FROM ( SELECT ALSubject FROM Subject_Table) t
method:-1
SELECT Row_Number() OVER (order by ALSubject asc) as ID , ALSubject AS Name FROM Subject_Table where ALSubject<>'' group by ALSubject


ID NAME
1 Accountancy
2 Applied Maths
3 Business Studies
4 Economics
5 Statistics
6 Zoology