check the error , quick get score

[plglenn9]

i wanna to get a data like this
1 a
2 b
3 c
the column is add by the symbol of identity key word ,any one help me ?

SELECT IDENTITY (1, 1) AS id, SubCategoryId
FROM Url
GROUP BY SubCategoryId

[feixianxxx]

IDENTITY 不能这么用

你可以这样 
SELECT IDENTITY (int,1, 1) AS id, SubCategoryId 
into  #
FROM Url 

select * from #

在SQL2005里面可以这样
select id=row_number()over(order by getdate()),SubCategoryId
from Url