SQL语句大全

SQL 语句教程

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