SQL Lesson 4: 查询结果Filtering过滤 和 sorting排序

1.【结果排序】按导演名排重列出所有电影(只显示导演)，并按导演名正序排列

 SELECT DISTINCT Director FROM movies ORDER BY Director ASC;

2.【结果排序】列出按上映年份最新上线的4部电影

 SELECT * FROM movies ORDER BY Year DESC LIMIT 4;

3.【结果排序】按电影名字母序升序排列，列出前5部电影

 SELECT * FROM movies ORDER BY Title ASC LIMIT 5;

4.【结果排序】按电影名字母序升序排列，列出上一题之后的5部电影

 SELECT * FROM movies ORDER BY Title ASC LIMIT 5 OFFSET 5;