sql server - Counting occurrences for each row and update to new column -
i have table: i need count occurrence of same line in column closetime , write number of occurrences in last column count clause item , same account. my single select concrete item , account select closetime, count(*) closetime statement account = 2013169 , item = 'eurusd' group closetime having count(*) > 1 order count(*) desc it possible count in 1 update query? depending on use case, not idea. better off creating "count" calculated column or leaving off base table entirely , creating view included count column. also, avoid trying have column name reserved word, count. however, if want it, can in 1 query. make sure on same page, belive trying group closetime , account , item not included in group (so, counted if same close time , different item), want able update target account , item. in case, like with cte1 (select closetime, count(*) numcount dbo.[statement] group closetime) update dbo.[statement] set [count] = cte1.numcount dbo.[statement] sd join...