SELECTDISTINCT department_id FROM departments ORDERBY department_id DESC
Mysql中 ‘+’ 号的作用
CONCAT 拼接函数(字符拼接)
SELECT CONCAT(last_name,first_name)as 姓名 FROM employees
IFNULL 函数:判断是否为NULL并返回指定值
SELECT IFNULL(commission_pct,0)as 奖金率,commission_pct FROM employees
条件查询运算符
ESCAPE 自定义转义符
select last_name FROM employees WHERE last_name LIKE'_$_%'ESCAPE'$'
模糊查询
SELECT last_name FROM employees WHERE last_name LIKE'%a%'SELECT last_name FROM employees WHERE last_name LIKE'__p_a%'SELECT last_name FROM employees WHERE last_name LIKE'_$_%'ESCAPE'$'SELECT*FROM employees WHERE salary BETWEEN10000AND15000SELECT last_name,salary FROM employees WHERE salary NOTBETWEEN8000AND17000ORDERBY salary DESCSELECT*FROM employees WHERE job_id IN('FI_MGR','AC_MGR','MK_MAN')SELECT*FROM employees WHERE commission_pct ISNULLSELECT*FROM employees WHERE commission_pct ISNOTNULL