摘要：主要介绍一些常用的子句，如 SELECT、WHERE、LIKE、GLOB、LIMIT、OFFSET、GROUP BY、HAVING、ORDER BY、DISTINCT 子句等。
WHERE子句以及AND、OR运算符
SELECT column1, column2, columnN
FROM table_name
WHERE [condition]
SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] AND [condition2]...AND [conditionN];
SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] OR [condition2]...OR [conditionN];
LIKE子句
SELECT column1, column2
FROM table_name
WHERE column1 LIKE pattern;
GLOB子句
SELECT FROM table_name WHERE column GLOB 'XXXX*';
SELECT FROM table_name WHERE column GLOB '*XXXX*';
SELECT FROM table_name WHERE column GLOB 'XXXX?';
SELECT FROM table_name WHERE column GLOB '?XXXX';
SELECT FROM table_name WHERE column GLOB '?XXXX?';
SELECT FROM table_name WHERE column GLOB '????';
LIMIT子句
SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows]
OFFSET子句
SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows] OFFSET [row num]
GROUP BY子句
SELECT column-list
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2....columnN
ORDER BY column1, column2....columnN
HAVING子句
SELECT column1, column2
FROM table1, table2
WHERE [ conditions ]
GROUP BY column1, column2
HAVING [ conditions ]
ORDER BY column1, column2
ORDER BY子句
SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];
DISTINCT关键字
SELECT DISTINCT column1, column2,.....columnN
FROM table_name
WHERE [condition]
注意
上述内容详讲见文章：SQLite的各种子句（内含案例）