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 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -