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
など
(ｓｅｌｅｃｔ ＊ ｆｒｏｍ ｐ)
SELECT * FROM P
(ｕｐｄａｔｅ ｏ ｓｅｔ ａ＝２００ ｗｈｅｒｅ ｉｄ＝１)
UPDATE O SET A=200 WHERE id=1
(ｄｅｌｅｔｅ ｆｒｏｍ ｅ ｗｈｅｒｅ ｉｄ＝５)
DELETE FROM E WHERE id=5
(ｃｒｅａｔｅ ｔａｂｌｅ ｕ（ｉｄ ｉｎｔ）)
CREATE TABLE U(id INT)
(ａｌｔｅｒ ｔａｂｌｅ ｕ ａｄｄ ｃｏｌ ｉｎｔ)
ALTER TABLE U ADD col INT
(ｄｒｏｐ ｔａｂｌｅ ｕ)
DROP TABLE U
(ｔｒｕｎｃａｔｅ ｔａｂｌｅ ｕ)
TRUNCATE TABLE U
(ｃｒｅａｔｅ ｉｎｄｅｘ ｉｄｘ ｏｎ ｕ（ｎａｍｅ）)
CREATE INDEX idx ON U(name)
(ｃｏｍｍｉｔ)
COMMIT
(ｓｅｌｅｃｔ ＊ ｆｒｏｍ ｕ)
SELECT * FROM U
(ｓｅｌｅｃｔ ｎａｍｅ ｆｒｏｍ ｕ)
SELECT Name FROM U
(ｓｅｌｅｃｔ ＊ ｆｒｏｍ ｕ ｗｈｅｒｅ ａ＞０)
SELECT * FROM U WHERE a>0
(ｉｎｓｅｒｔ ｉｎｔｏ ｕ ｖａｌｕｅｓ（１）)
INSERT INTO U VALUES(1)
(ｕｐｄａｔｅ ｕ ｓｅｔ ａ＝２)
UPDATE U SET a=2
(ｄｅｌｅｔｅ ｆｒｏｍ ｕ ｗｈｅｒｅ ａ＝０)
DELETE FROM U WHERE a=0
(ｃｒｅａｔｅ ｄａｔａｂａｓｅ ｄ)
CREATE DATABASE D
(ｃｒｅａｔｅ ｔａｂｌｅ ｏ（ｉｄ ｉｎｔ）)
CREATE TABLE O(id INT)
(ｓｅｌｅｃｔ ＊ ｆｒｏｍ ａ ｊｏｉｎ ｂ ｏｎ ａ．ｉｄ＝ｂ．ｉｄ)
SELECT * FROM A JOIN B ON A.id=B.id
(ｄｒｏｐ ｄａｔａｂａｓｅ ｄ)
DROP DATABASE D