列出表格中所有欄位的資料
SELECT * FROM 表格
例:SELECT * FROM departments;
從表格篩選列出某欄位的資料
SELECT 欄位 FROM 表格
例:SELECT employee_id , last_name FROM employees;
SELECT last_name, salary, 12*salary+100 FROM employees;
SELECT 欄位 FROM 表格
例:SELECT employee_id , last_name FROM employees;
SELECT last_name, salary, 12*salary+100 FROM employees;
替要篩選的欄位取匿名
SELECT 欄位 "別名" FROM 表格
SELECT 欄位 AS "別名" FROM 表格
例:SELECT employee_id "Emp #", last_name "Employee" FROM employees;
SELECT last_name "Name", salary*12 "Annual Salary" FROM employees;
0
意見
SELECT 欄位 "別名" FROM 表格
SELECT 欄位 AS "別名" FROM 表格
例:SELECT employee_id "Emp #", last_name "Employee" FROM employees;
SELECT last_name "Name", salary*12 "Annual Salary" FROM employees;