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