只是個人筆記~~
MIN and MAX
SELECT MAX(column1)
FROM table_name
WHERE condition;
SELECT MIN(column1)
FROM table_name
WHERE condition;
COUNT AVG SUM
SELECT AVG(column1)
FROM table_name
WHERE condition;
SELECT SUM(column1)
FROM table_name
WHERE condition;
SELECT COUNT(column)
FROM table_name
WHERE condition;
LIKE(比對)
無大小寫分別
%是零或多個任意字元 _是1個任意字元
SELECT *
FROM table_name
WHERE column1 LIKE 'a%';
MS Access uses a question mark (?) instead of the underscore (_).
[charset] 代表屬於charset的任意字元
[!charset] 代表不屬於charset的任意字元
[!charset] 代表不屬於charset的任意字元
SELECT *
FROM table_name
WHERE column1 NOT LIKE 'a_%_';
SELECT *
FROM table_name
WHERE column1 LIKE '[abc]%';
IN
SELECT *
FROM table_name
WHERE column1 IN (c1,c2,c3...);
以下是一句廢話
SELECT * FROM Customers
WHERE CustomerID IN (SELECT CustomerID FROM Customers);
SELECT *
FROM table_name
WHERE column1 NOT IN (c1,c2,c3...);
BETWEEN
邊界包含
SELECT *
FROM table_name
WHERE (column1 BETWEEN 1 AND 20)
AND column2 NOT IN (c1,c2);
SELECT *
FROM table_name
WHERE c1 NOT BETWEEN 1 AND 2;
AS
SELECT column1 AS c1
FROM table_name;
SELECT column1,column2
FROM table_name
AS cc;