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) 函數(shù)..................................................................................................................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 |
|