求一个sql

[myccc456]

把age小于等于10岁的，都统一成10岁。
其他的年龄则是多少就多少，放在另外一个字段age1中.

[shoppo0505]

select *, case when age<=10 then 10, else age end as age1 from table

[唐诗三百首]

 update [表名] set age1=case when age<=10 then 10 else age end

[qq793465031]

update table set age='10' where age<=10

[choueric]

update table set age1 = (case when age < 10 then 10 else age end )

[-Tracy-McGrady-]

select age=(case when age<=10 then 10 else age end)from tb