UNION, LIMIT

UNION

将多张表的查询结果无脑地连接在一起

SELECT ENAME FROM EMP
UNION
SELECT DNAME FROM DEPT;

# 需注意，表查询语句中字段数量需相等

LIMIT

LIMIT startIndex, length

# startIndex 从 0 开始

# 显示第5-10条记录

LIMIT 4，6