Question

用SQL显示student表中的学生的姓名，性别，年龄加1的结果

Answer 1

select s_name 学生姓名，s_gender 性别，s_age =s_age=1 年龄 from student;

Answer 2

select a.name,age = (a.sex,a.age + 1) from student a

Answer 3

select a.name,a.sex,a.age + 1 as age from student a