SQL３　例文

(ｓｅｌｅｃｔ　ｃｏｕｎｔ（＊）　ｆｒｏｍ　ｏｒｄｅｒｓ；)

SELECT COUNT(*) FROM Orders;

(ｓｅｌｅｃｔ　ｓｕｍ（ａｍｏｕｎｔ）　ｆｒｏｍ　ｏｒｄｅｒｓ；)

SELECT SUM(Amount) FROM Orders;

(ｓｅｌｅｃｔ　ａｖｇ（ｐｒｉｃｅ）　ｆｒｏｍ　ｐｒｏｄｕｃｔｓ；)

SELECT AVG(Price) FROM Products;

(ｓｅｌｅｃｔ　ｍｉｎ（ａｇｅ）　ｆｒｏｍ　ｃｕｓｔｏｍｅｒｓ；)

SELECT MIN(Age) FROM Customers;

(ｓｅｌｅｃｔ　ｍａｘ（ｓａｌａｒｙ）　ｆｒｏｍ　ｅｍｐｌｏｙｅｅｓ；)

SELECT MAX(Salary) FROM Employees;

(ｓｅｌｅｃｔ　ｕｐｐｅｒ（ｎａｍｅ）　ｆｒｏｍ　ｃｕｓｔｏｍｅｒｓ；)

SELECT UPPER(Name) FROM Customers;

(ｓｅｌｅｃｔ　ｌｏｗｅｒ（ｅｍａｉｌ）　ｆｒｏｍ　ｕｓｅｒｓ；)

SELECT LOWER(Email) FROM Users;

(ｓｅｌｅｃｔ　ｌｅｎｇｔｈ（ｄｅｓｃ）　ｆｒｏｍ　ｐｒｏｄ；)

SELECT LENGTH(Desc) FROM Prod;

(ｓｅｌｅｃｔ　ｎｏｗ（）；)

SELECT NOW();

(ｓｅｌｅｃｔ　ｒｏｕｎｄ（ｐｒｉｃｅ，２）　ｆｒｏｍ　ｐｒｏｄ；)

SELECT ROUND(Price,2) FROM Prod;

(ｓｅｌｅｃｔ　ｎａｍｅ，ａｇｅ　ｆｒｏｍ　ｃｕｓｔ；)

SELECT Name,Age FROM Cust;

(ｆｒｏｍ　ｏｒｄｅｒｓ；)

FROM Orders;

(ｓｅｌｅｃｔ　＊　ｆｒｏｍ　ｃｕｓｔ　ｗｈｅｒｅ　ａｇｅ＞３０；)

SELECT * FROM Cust WHERE Age>30;

(ｓｅｌｅｃｔ　ｄ，ｃｏｕｎｔ（＊）　ｆｒｏｍ　ｅ　ｇｒｏｕｐ　ｂｙ　ｄ)

SELECT D,COUNT(*) FROM E GROUP BY D

(ｓｅｌｅｃｔ　１　ｆｒｏｍ　ｅ　ｈａｖｉｎｇ　１＝１)

SELECT 1 FROM E HAVING 1=1

(ｓｅｌｅｃｔ　＊　ｆｒｏｍ　ｅｍｐ　ｏｒｄｅｒ　ｂｙ　ｓａｌ　ｄｅｓｃ)

SELECT * FROM Emp ORDER BY Sal DESC

(ｓｅｌｅｃｔ　＊　ｆｒｏｍ　ａ　ｊｏｉｎ　ｂ　ｏｎ　ａ．ｉｄ＝ｂ．ｉｄ)

SELECT * FROM A JOIN B ON A.id=B.id

(ｏｎ　ａ．ｉｄ＝ｂ．ｉｄ)

ON A.id=B.id

(ｓｅｌｅｃｔ　＊　ｆｒｏｍ　ｐ　ｌｉｍｉｔ　１０)

SELECT * FROM P LIMIT 10

(ｓｅｌｅｃｔ　ｎａｍｅ　ａｓ　ｎ　ｆｒｏｍ　ｃ)

SELECT Name AS N FROM C