算术运算符:
例:
select 100,100+0,100*10,100/10 from dual;
比较运算符:
= 例子:
SELECT 1=2 FROM DUAL; 真返回1 假返回0
安全等于 <=> 例子:
SELECT null<=>null FROM DUAL; 可以对NULL进行计算
非符号比较运算符
is null 例子:
SELECT null is null FROM DUAL; 真返回1 假返回0
SELECT null is not null FROM DUAL; 真返回1 假返回0
最大值最小值例子:
SELECT LEAST(1,2),GREATEST(1,5) FROM DUAL;
BETWEEN 查询范围内的数据例子:
SELECT `flask`.indicators.iyear
FROM `flask`.indicators
WHERE iyear BETWEEN 1960 and 1980;
link模糊查询:
SELECT `flask`.indicators.iyear
FROM `flask`.indicators
WHERE iyear link 'a%' 查询a开头的员工信息
SELECT `flask`.indicators.iyear
FROM `flask`.indicators
WHERE iyear link '__a%' 查询第三个字符是a开头的员工信息