SQL语句

sql_select：SELECT CustomerName, City FROM Customers;

sql_distinct：SELECT DISTINCT Country FROM Customers; (去重)

sql_where：SELECT * FROM Customers WHERE Country='Mexico';

sql_orderby：SELECT * FROM Products ORDER BY Price;

sql_and：SELECT * FROM Customers WHERE Country = 'Spain' AND CustomerName LIKE 'G%';

sql_or：SELECT * FROM Customers WHERE Country = 'Germany' OR Country = 'Spain';

sql_not：SELECT * FROM Customers WHERE NOT Country = 'Spain';

sql_insert：INSERT INTO Customers (CustomerName, City, Country) VALUES ('Cardinal', 'Stavanger', 'Norway');

sql_null_values：SELECT CustomerName, ContactName, Address FROM Customers WHERE Address IS NOT NULL;

sql_update：UPDATE Customers SET ContactName = 'Alfred Schmidt', City= 'Frankfurt' WHERE CustomerID = 1;

sql_delete：DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

sql_top：SELECT TOP 3 * FROM Customers;

sql_min：SELECT MIN(Price) FROM Products;

sql_max：SELECT MAX(Price) FROM Products;

sql_count：SELECT COUNT(*) FROM Products;

sql_sum：SELECT SUM(Quantity) AS total FROM OrderDetails;

sql_avg：SELECT AVG(Price) AS [average price]FROM Products;

sql_like：SELECT * FROM Customers WHERE CustomerName LIKE 'a%';

sql_wildcards：SELECT * FROM Customers WHERE CustomerName LIKE 'a%';

sql_in：SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'UK');

sql_not_in：SELECT * FROM Customers WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders);

sql_between：SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;

sql_alias：SELECT CustomerID AS ID FROM Customers;

sql_join：SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

sql_join_inner：SELECT ProductID, ProductName, CategoryName FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;

sql_join_left：SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

sql_join_right：SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

sql_join_full：SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition;

sql_join_self：SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;

sql_union：SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2;

sql_groupby：SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) ORDER BY column_name(s);

sql_having：SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition ORDER BY column_name(s);

sql_exists：SELECT column_name(s) FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition);

sql_any_all：SELECT ALL column_name(s) FROM table_name WHERE condition;

sql_select_into：SELECT * INTO CustomersBackup2017 FROM Customers;

sql_insert_into_select：INSERT INTO Customers (CustomerName, City, Country) SELECT SupplierName, City, Country FROM Suppliers;

sql_case：SELECT CustomerName, City, Country FROM Customers ORDER BY (CASE WHEN City IS NULL THEN Country ELSE City END);

sql_isnull：SELECT ProductName, UnitPrice * (UnitsInStock + UnitsOnOrder) FROM Products;