with p_x as (
select [id]
,[name]
,[classid]
,[orderid], ROW_NUMBER() OVER(Partition by classid order by orderid) as rowid FROM table
)
select * from p_x
with p_x as (
select [id]
,[name]
,[classid]
,[orderid], ROW_NUMBER() OVER( order by orderid) as rowid FROM table
)
select * from p_x