SELECT
    字段列表
FROM
    表名列表
WHERE
    條件列表
GROUP BY
    分組字段列表
HAVING
    分組后條件列表
ORDER BY 
    排序字段列表
LIMIT 
    分頁參數(shù)

CREATE TABLE emp
(

ID INT COMMENT '編號(hào)',

WORKNO VARCHAR(10) COMMENT '工號(hào)',

NAME VARCHAR(10) COMMENT '姓名',

GENDER CHAR(1) COMMENT '性別',

AGE TINYINT UNSIGNED COMMENT '年齡',

IDCARD CHAR(18) COMMENT '身份證號(hào)',

WORKADDRESS VARCHAR(50) COMMENT '工作地址',

ENTRYDATE DATE COMMENT '入職時(shí)間'

) COMMENT '員工表';

INSERT INTO emp (ID, WORKNO, NAME, GENDER, AGE, IDCARD, WORKADDRESS, ENTRYDATE)

VALUES (1, '1', '柳巖', '女', 20, '123456789012345678', '北京', '2000-01-01'),

(2, '2', '張無忌', '男', 18, '123456789012345670', '北京', '2005-09-01'),

(3, '3', '韋一笑', '男', 38, '123456789012345670', '上海', '2005-08-01'),

(4, '4', '趙敏', '女', 18, '123456789012345670', '北京', '2009-12-01'),

(5, '5', '小昭', '女', 16, '123456789012345678', '上海', '2007-07-01'),

(6, '6', '楊逍', '男', 28, '12345678901234567X', '北京', '2006-01-01'),

(7, '7', '范瑤', '男', 40, '123456789012345670', '北京', '2005-05-01'),

(8, '8', '黛綺絲', '女', 38, '123456789012345670', '天津', '2015-05-01'),

(9, '9', '范涼涼', '女', 45, '123456789012345678', '北京', '2010-04-01'),

(10, '10', '陳友諒', '男', 53, '123456789012345670', '上海', '2011-01-01'),

(11, '11', '張士誠', '男', 55, '123456789012345670', '江蘇', '2015-05-01'),

(12, '12', '常遇春', '男', 32, '123456789012345670', '北京', '2004-02-01'),

(13, '13', '張三豐', '男', 88, '123456789012345678', '江蘇', '2020-11-01'),

(14, '14', '滅絕', '女', 65, '123456789012345670', '西安', '2019-05-01'),

(15, '15', '胡青牛', '男', 70, '12345678901234567X', '西安', '2018-04-01'),

(16, '16', '周芷若', '女', 18, NULL, '北京', '2012-06-01');

select name, WORKNO,AGE from emp;

select * from emp;

select WORKADDRESS from emp;

select WORKADDRESS as '工作地址' from emp;

select distinct WORKADDRESS as '工作地址' from emp;