运算符包括: >:大于号 …>=:大于等于
=:等于号
<:小于号
<=:小于等于
<>:不等于
select * from student where age>50 and age<70
返回一个值的子查询
当子查询的返回值只有一个时,可以使用比较运算符如=、<、>、>=、<=、!=等将富查询和子查询连接起来。实例如下:
简单子查询
select name,age
from person
where age > ( select age
from person
where name = ‘张三’);
#列的运算
SELECT g.sgrade “成绩”, g.sgrade + 0.99 “新成绩”
FROM grade g;
#列的运算,如果某列为空
CREATE TABLE grade_copy LIKE grade;
INSERT INTO grade_copy SELECT * FROM grade WHERE sgrade >= 70;
SELECT * FROM grade_copy;
UPDATE grade_copy SET sgrade = NULL WHERE selectdate=‘2018’;
SELECT g.sgrade “成绩”, g.sgrade + 0.99 “新成绩”
FROM grade_copy g;