34,594
社区成员
发帖
与我相关
我的任务
分享
update student set age = age + 10 from(select top(1) id from student where age<15 order by age asc) TB_TOP where TB_TOP.id = student.id
update student set age = age + 10 where TB_TOP.id = (select top(1) id from student where age<15 order by age asc)
update TB_TOP set age=age+10
from(select top 1 * from student order by desc)TB_TOP