數據分析人員必須掌握的一些sql語句
來源:果殼範文吧 7.68K
i got it.
do you?
SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL LIKE
SQL ORDER BY
SQL 函數
SQL COUNT
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL 表格連接
SQL 外部連接
SQL Subquery
SQL UNION
SQL UNION ALL
SQL INTERSECT
SQL MINUS
SQL CONCATENATE
SQL SUBSTRING
SQL TRIM
SQL CREATE TABLE
SQL CREATE VIEW
SQL CREATE INDEX
SQL ALTER TABLE
SQL 主鍵
SQL 外來鍵
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM