1、where子句操作符
---------------------------------------------------------------------
例:
SELECT a,b
FROM 表1
WHERE a<=99
-------------------------------------------------------------------
2、范围值(BETWEEN AND)
--------------------------------------------------------------------
例:
SELECT a,b
FROM 表1
WHERE a BETWEEN 6 AND 66;
--------------------------------------------------------------------
包含开始值和结束值
3、空值检查(null)
---------------------------------------------------------------------
例:
SELECT a,b
FROM 表1
WHERE a is NULL;
----------------------------------------------------------------------