how to use group by in update query in sql server

Try below script-

UPDATE Your_table SET name='HIGH' WHERE age IN (SELECT MAX(age) FROM Your_table GROUP BY TYPE);

0

Hi,

try like this

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

0

Try below query:

update table1

set name='HIGH'

where age in (select max(age) from table1 group by type);

0

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

0

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

0