sql server - UPDATE SQL Statement with group by (using a self join) to the same table -

i have sample data set

bookid book_name book_version_number  new book version number (proposed) 1       xyz      1.0000               1.0000 1       xyz      1.0000               2.0000 2       abc      1.0000               1.0000 2       abc      1.0000               2.0000 2       abc      1.0000               3.0000 

so, need incrementally , sequentially update new book version number grouped title..

i need put update sql..my update seems failing group clause not working

you use cte , row_number():

;with cte (     select bookid,             bookname,             book_version_number,            row_number() over(partition bookid order (select null)) rn     tablename )  update cte set book_version_number = rn