MSSQL数据查询

--1.查询出姓名为“陈鹏”的学号、手机号码和邮箱地址
Select SNO AS '学号',MobileNO AS '手机号码',StuEMail AS '邮箱地址'
From Student
Where SName='陈鹏'

--2.查询出姓名不是“陈鹏”的学生的所有信息
Select SNO AS '学号', SName AS '姓名', Sage As '年龄', Sex AS '性别', MobileNO AS '手机号码', StuEMail AS '邮箱地址'
From Student
Where SName<>'陈鹏'

--3.查询出学生年龄介于20到30间的学生学号和姓名
Select SNO As '学号',SName As '姓名'
From Student 
Where Sage between 20 And