Question

sql将表student前四位学生的年龄增加一岁，怎么做呢 前四位怎么表示

Answer 1

select age+1 as 年龄 from student where id<5

Answer 2

update student set age=age+1
where id in (select top 4 id from student order by id)

Answer 3

要看是什颂吵么数野基侍据库：
sqlServer：update student set age=age+1 where id in (select top 4 id from student order by id)
mysql：update student set age = age+1 order by id limit 0,3；锋薯

Answer 4

上面的看到 都觉得可以赞同