查询结果Filtering过滤 和 sorting排序

(1)DISTINCT 语法会直接删除重复的行
SELECT DISTINCT Director From Movies
(2)ORDER BY
SELECT column, another_column, …
FROM mytable
WHERE condition(s)
ORDER BY column ASC/DESC;
(3)Limit选取部分结果
SELECT column, another_column, …
FROM mytable
WHERE condition(s)
ORDER BY column ASC/DESC
LIMIT 5 OFFSET 2;
截取5个，从第2个开始截（截的结果不包括第二个）

/SELECT DISTINCT Director From Movies
SELECT * FROM Movies ORDER BY Year DESC LIMIT 4 OFFSET 1
SELECT * FROM Movies ORDER BY Title ASC LIMIT 5
SELECT * FROM Movies ORDER BY Title ASC LIMIT 5 OFFSET 5;
SELECT Title FROM Movies WHERE Director = ‘John Lasseter’ ORDER BY Length_minutes DESC LIMIT 1 OFFSET 2/