how to use group by in update query in sql server

Question

how to use group by in update query in sql server without using join

Upendra Pratap Shahi · Answer

Hello Rohan Gupta  Try below script- UPDATE Your_table SET name = 'HIGH' WHERE age IN ( SELECT MAX ( age ) FROM Your_table GROUP BY TYPE );

Govinda Rajulu Yemineni · Answer

Hi try like this update table1 set name='HIGH' where age in(select max(age) from table1 group by type);

Manas Mohapatra · Answer

Try below query: update table1 set name='HIGH' where age in (select max(age) from table1 group by type);

Amitesh Verma · Answer

update table1 set name='HIGH' having age in(select max(age) from table1 group by type);

Pranay Rana · Answer

Can you please expalain in detail about this  and what you have tried till now.