一.基本Select语句:
SELECT *|{[DISTINCT] column|expression[alias],...}
FROM table;
1.SELECT * FROM departments; //查询所有的
2.SELECT department_id, location_id FROM departments; //指定列
算术表达式: * / + - (按优先级)
1.SELECT last_name, salary, salary + 300 FROM employees;
2.SELECT last_name, salary, 12*salary+100 FROM employees; //优先级
3.SELECT last_name, salary, 12*(salary+100) FROM employees; //使用括号
4.包含空值的算术表达式计算结果为空
使用列名:
1.SELECT last_name AS name, commission_pct comm FROM employees;
连接字符运算: ||
1.SELECTlast_name||job_id AS "Employees" FROM employees;
文字字符串
1.SELECT last_name||' is a '||job_id AS "Employee Details" FROM employees;
出去相同的行(SELECT 默认显示相同的行):DISTINCT
1.SELECT DISTINCT department_id FROM employees;