問題一覧
1
aggregate function
2
MIN
3
MAX
4
COUNT
5
SUM
6
AVG
7
GROUP BY
8
SELECT MIN(column_name) FROM table_name;
9
SELECT MAX(column_name) FROM table_name;
10
SELECT COUNT(column_name) FROM table_name;
11
SELECT SUM(column_name) FROM table_name;
12
SELECT AVG(column_name) FROM table_name;
13
SELECT columns FROM table_name GROUP BY columns;
14
Alias
15
SELECT column_name AS alias FROM table_name;
16
SELECT columns FROM table_name GROUP BY columns HAVING condition;
17
HAVING
18
YEAR
19
MONTH
20
DAY
21
GETDATE
22
DATEADD
23
DATEDIFF
24
SELECT OrderID, YEAR(OrderDate) AS Year;
25
SELECT OrderID, MONTH(OrderDate) AS Month;
26
SELECT OrderID, DAY(OrderDate) AS Day;
27
SELECT GETDATE();
28
DATEADD(datepart, number, date);
29
DATEDIFF(datepart, date1, date2);
30
ABS
31
CEILING
32
FLOOR
33
SELECT ABS(-234.5);
34
ROUND(number, decimal places);
35
SELECT CEILING(234.1);
36
SELECT FLOOR(234.5);
37
CONCAT
38
LOWER
39
UPPER
40
SUBSTRING
41
LEN
42
TRIM
43
SELECT CONCAT(FirstName + ' ' , LastName) FROM Customers WHERE CustomerID = 3446;
44
SELECT LOWER ('FUNCTIONS');
45
SELECT UPPER('sql');
46
SELECT SUBSTRING('SQL Functions', 1, 3);
47
SELECT LEN('SQL Functions');
48
SELECT TRIM('<!> ' FROM ' <Functions! >');
49
JOIN
50
INNER JOIN
51
LEFT JOIN
52
RIGHT JOIN
53
FULL JOIN
54
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
55
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
56
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
57
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers FULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
58
2021-02-14 00:00:00.000
59
2020-08-14 00:00:00.000
60
2020-02-14 02:30:00.000
61
235
62
234
63
SQL
64
13
The Contemporary World Mock test (Prelims)
The Contemporary World Mock test (Prelims)
Xai Alexandrei Delos Reyes · 58問 · 2年前The Contemporary World Mock test (Prelims)
The Contemporary World Mock test (Prelims)
58問 • 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
Xai Alexandrei Delos Reyes · 67問 · 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
67問 • 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 64問 · 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
64問 • 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 23問 · 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
23問 • 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 76問 · 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
76問 • 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 48問 · 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
48問 • 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 52問 · 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
52問 • 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
Xai Alexandrei Delos Reyes · 40問 · 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
40問 • 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 38問 · 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
38問 • 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 28問 · 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
28問 • 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 24問 · 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
24問 • 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
Xai Alexandrei Delos Reyes · 26問 · 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
26問 • 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
Xai Alexandrei Delos Reyes · 19問 · 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
19問 • 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
Xai Alexandrei Delos Reyes · 36問 · 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
36問 • 2年前Computing Mock Test Finals
Computing Mock Test Finals
Xai Alexandrei Delos Reyes · 26問 · 2年前Computing Mock Test Finals
Computing Mock Test Finals
26問 • 2年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 63問 · 1年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
63問 • 1年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 36問 · 1年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
36問 • 1年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 56問 · 1年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
56問 • 1年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
Xai Alexandrei Delos Reyes · 45問 · 1年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
45問 • 1年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 40問 · 1年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
40問 • 1年前問題一覧
1
aggregate function
2
MIN
3
MAX
4
COUNT
5
SUM
6
AVG
7
GROUP BY
8
SELECT MIN(column_name) FROM table_name;
9
SELECT MAX(column_name) FROM table_name;
10
SELECT COUNT(column_name) FROM table_name;
11
SELECT SUM(column_name) FROM table_name;
12
SELECT AVG(column_name) FROM table_name;
13
SELECT columns FROM table_name GROUP BY columns;
14
Alias
15
SELECT column_name AS alias FROM table_name;
16
SELECT columns FROM table_name GROUP BY columns HAVING condition;
17
HAVING
18
YEAR
19
MONTH
20
DAY
21
GETDATE
22
DATEADD
23
DATEDIFF
24
SELECT OrderID, YEAR(OrderDate) AS Year;
25
SELECT OrderID, MONTH(OrderDate) AS Month;
26
SELECT OrderID, DAY(OrderDate) AS Day;
27
SELECT GETDATE();
28
DATEADD(datepart, number, date);
29
DATEDIFF(datepart, date1, date2);
30
ABS
31
CEILING
32
FLOOR
33
SELECT ABS(-234.5);
34
ROUND(number, decimal places);
35
SELECT CEILING(234.1);
36
SELECT FLOOR(234.5);
37
CONCAT
38
LOWER
39
UPPER
40
SUBSTRING
41
LEN
42
TRIM
43
SELECT CONCAT(FirstName + ' ' , LastName) FROM Customers WHERE CustomerID = 3446;
44
SELECT LOWER ('FUNCTIONS');
45
SELECT UPPER('sql');
46
SELECT SUBSTRING('SQL Functions', 1, 3);
47
SELECT LEN('SQL Functions');
48
SELECT TRIM('<!> ' FROM ' <Functions! >');
49
JOIN
50
INNER JOIN
51
LEFT JOIN
52
RIGHT JOIN
53
FULL JOIN
54
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
55
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
56
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
57
SELECT Customers.CustomerID, Customers.FirstName, Orders.OrderID FROM Customers FULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
58
2021-02-14 00:00:00.000
59
2020-08-14 00:00:00.000
60
2020-02-14 02:30:00.000
61
235
62
234
63
SQL
64
13