SQL lesson4 提炼和排序

KEY WORD:

distinct    独一无二的

Select query with unique results
SELECT DISTINCT column, another_column, …
FROM mytable
WHERE condition(s);

SELECT DISTINCT director 
FROM movies

ASC

ascending 上升的

DESC

descending下降的

排序

Select query with ordered results
SELECT column, another_column, …
FROM mytable
WHERE condition(s)
ORDER BY column ASC/DESC

LIMIT  限制几行

Select query with limited rows
SELECT column, another_column, …
FROM mytable
WHERE condition(s)
ORDER BY column ASC/DESC
LIMIT num_limit OFFSET num_offset;

OFFSET 限制其他的行数不显示