基本Select语句

 一.基本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;