SQL语句(01) SELECT 2 SQL语句(02) DISTINCT 2 SQL语句(03) WHERE 2 SQL语句(04) AND OR 2 SQL语句(05) IN 2 SQL语句(06) BETWEEN 3 SQL语句(07) LIKE 3 SQL语句(08) ORDER BY 3 SQL语句(09)函数3 SQL语句(10) COUNT 3 SQL语句(11) Group By 4 SQL语句(12) HAVING 4 SQL语句(13) ALIAS 4 SQL语句(14)连接4 SQL语句(15)外部连接5 SQL语句(16) Subquery 6 SQL语句(17) UNION 6 SQL语句(18) UNION ALL 6 SQL语句(19) INTERSECT 7 SQL语句(20) MINUS 7 SQL语句(21) Concatenate 8 SQL语句(22) Substring 8 SQL语句(23) TRIM 9 SQL语句(24) Create Table 9 SQL语句(25) Create View 9 SQL语句(26) Create Index 10 SQL语句(27) Alter Table 10 SQL语句(28)主键11 SQL语句(29)外来键11 SQL语句(30) Drop Table 12 SQL语句(31) Truncate Table 12 SQL语句(32) Insert Into 12 SQL语句(33) Update 13 SQL语句(34) Delete 13