SQL - 참조 - 키워드 - BETWEEN

BETWEEN

BETWEEN 명령은 주어진 범위 내에서 값을 선택하는 데 사용된다.
여기에서 사용되는 값은 숫자, 텍스트 또는 날짜일 수 있고 BETWEEN 명령에는 시작 및 끝 값이 포함된다.

예시

가격이 10과 20 사이인 모든 제품을 선택한다.

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18
2	Chang	1	1	24 – 12 oz bottles	19
3	Aniseed Syrup	1	2	12 – 550 ml bottles	10
15	Genen Shouyu	6	2	24 – 250 ml bottles	15.5
16	Pavlova	7	3	32 – 500 g boxes	17.45
21	Sir Rodney’s Scones	8	3	24 pkgs. x 4 pieces	10
25	NuNuCa Nuß-Nougat-Creme	11	3	20 – 450 g glasses	14
31	Gorgonzola Telino	14	4	12 – 100 g pkgs	12.5
34	Sasquatch Ale	16	1	24 – 12 oz bottles	14
35	Steeleye Stout	16	1	24 – 12 oz bottles	18
36	Inlagd Sill	17	8	24 – 250 g jars	19
39	Chartreuse verte	18	1	750 cc per bottle	18
40	Boston Crab Meat	19	8	24 – 4 oz tins	18.4
42	Singaporean Hokkien Fried Mee	20	5	32 – 1 kg pkgs.	14
44	Gula Malacca	20	2	20 – 2 kg bags	19.45
46	Spegesild	21	8	4 – 450 g glasses	12
48	Chocolade	22	3	10 pkgs.	12.75
49	Maxilaku	23	3	24 – 50 g pkgs.	20
50	Valkoinen suklaa	23	3	12 – 100 g bars	16.25
57	Ravioli Angelo	26	5	24 – 250 g pkgs.	19.5
58	Escargots de Bourgogne	27	8	24 pieces	13.25
66	Louisiana Hot Spiced Okra	2	2	24 – 8 oz jars	17
67	Laughing Lumberjack Lager	16	1	24 – 12 oz bottles	14
68	Scottish Longbreads	8	3	10 boxes x 8 pieces	12.5
70	Outback Lager	7	1	24 – 355 ml bottles	15
73	Röd Kaviar	17	8	24 – 150 g jars	15
74	Longlife Tofu	4	7	5 kg pkg.	10
76	Lakkalikööri	23	1	500 ml	18
77	Original Frankfurter grüne Soße	12	2	12 boxes	13

예의 범위를 벗어난 제품을 표시하려면 NOT BETWEEN을 사용

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
4	Chef Anton’s Cajun Seasoning	2	2	48 – 6 oz jars	22
5	Chef Anton’s Gumbo Mix	2	2	36 boxes	21.35
6	Grandma’s Boysenberry Spread	3	2	12 – 8 oz jars	25
7	Uncle Bob’s Organic Dried Pears	3	7	12 – 1 lb pkgs.	30
8	Northwoods Cranberry Sauce	3	2	12 – 12 oz jars	40
9	Mishi Kobe Niku	4	6	18 – 500 g pkgs.	97
10	Ikura	4	8	12 – 200 ml jars	31
11	Queso Cabrales	5	4	1 kg pkg.	21
12	Queso Manchego La Pastora	5	4	10 – 500 g pkgs.	38
13	Konbu	6	8	2 kg box	6
14	Tofu	6	7	40 – 100 g pkgs.	23.25
17	Alice Mutton	7	6	20 – 1 kg tins	39
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5
19	Teatime Chocolate Biscuits	8	3	10 boxes x 12 pieces	9.2
20	Sir Rodney’s Marmalade	8	3	30 gift boxes	81
22	Gustaf’s Knäckebröd	9	5	24 – 500 g pkgs.	21
23	Tunnbröd	9	5	12 – 250 g pkgs.	9
24	Guaraná Fantástica	10	1	12 – 355 ml cans	4.5
26	Gumbär Gummibärchen	11	3	100 – 250 g bags	31.23
27	Schoggi Schokolade	11	3	100 – 100 g pieces	43.9
28	Rössle Sauerkraut	12	7	25 – 825 g cans	45.6
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.79
30	Nord-Ost Matjeshering	13	8	10 – 200 g glasses	25.89
32	Mascarpone Fabioli	14	4	24 – 200 g pkgs.	32
33	Geitost	15	4	500 g	2.5
37	Gravad lax	17	8	12 – 500 g pkgs.	26
38	Côte de Blaye	18	1	12 – 75 cl bottles	263.5
41	Jack’s New England Clam Chowder	19	8	12 – 12 oz cans	9.65
43	Ipoh Coffee	20	1	16 – 500 g tins	46
45	Røgede sild	21	8	1k pkg.	9.5
47	Zaanse koeken	22	3	10 – 4 oz boxes	9.5
51	Manjimup Dried Apples	24	7	50 – 300 g pkgs.	53
52	Filo Mix	24	5	16 – 2 kg boxes	7
53	Perth Pasties	24	6	48 pieces	32.8
54	Tourtière	25	6	16 pies	7.45
55	Pâté chinois	25	6	24 boxes x 2 pies	24
56	Gnocchi di nonna Alice	26	5	24 – 250 g pkgs.	38
59	Raclette Courdavault	28	4	5 kg pkg.	55
60	Camembert Pierrot	28	4	15 – 300 g rounds	34
61	Sirop d’érable	29	2	24 – 500 ml bottles	28.5
62	Tarte au sucre	29	3	48 pies	49.3
63	Vegie-spread	7	2	15 – 625 g jars	43.9
64	Wimmers gute Semmelknödel	12	5	20 bags x 4 pieces	33.25
65	Louisiana Fiery Hot Pepper Sauce	2	2	32 – 8 oz bottles	21.05
69	Gudbrandsdalsost	15	4	10 kg pkg.	36
71	Fløtemysost	15	4	10 – 500 g pkgs.	21.5
72	Mozzarella di Giovanni	14	4	24 – 200 g pkgs.	34.8
75	Rhönbräu Klosterbier	12	1	24 – 0.5 l bottles	7.75

ProductName이 ‘Carnarvon Tigers’와 ‘Mozzarella di Giovanni’ 사이에 있는 모든 제품을 선택한다.

SELECT * FROM Products
WHERE ProductName BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5
1	Chais	1	1	10 boxes x 20 bags	18
2	Chang	1	1	24 – 12 oz bottles	19
39	Chartreuse verte	18	1	750 cc per bottle	18
4	Chef Anton’s Cajun Seasoning	2	2	48 – 6 oz jars	22
5	Chef Anton’s Gumbo Mix	2	2	36 boxes	21.35
48	Chocolade	22	3	10 pkgs.	12.75
38	Côte de Blaye	18	1	12 – 75 cl bottles	263.5
58	Escargots de Bourgogne	27	8	24 pieces	13.25
52	Filo Mix	24	5	16 – 2 kg boxes	7
71	Fløtemysost	15	4	10 – 500 g pkgs.	21.5
33	Geitost	15	4	500 g	2.5
15	Genen Shouyu	6	2	24 – 250 ml bottles	15.5
56	Gnocchi di nonna Alice	26	5	24 – 250 g pkgs.	38
31	Gorgonzola Telino	14	4	12 – 100 g pkgs	12.5
6	Grandma’s Boysenberry Spread	3	2	12 – 8 oz jars	25
37	Gravad lax	17	8	12 – 500 g pkgs.	26
24	Guaraná Fantástica	10	1	12 – 355 ml cans	4.5
69	Gudbrandsdalsost	15	4	10 kg pkg.	36
44	Gula Malacca	20	2	20 – 2 kg bags	19.45
26	Gumbär Gummibärchen	11	3	100 – 250 g bags	31.23
22	Gustaf’s Knäckebröd	9	5	24 – 500 g pkgs.	21
10	Ikura	4	8	12 – 200 ml jars	31
36	Inlagd Sill	17	8	24 – 250 g jars	19
43	Ipoh Coffee	20	1	16 – 500 g tins	46
41	Jack’s New England Clam Chowder	19	8	12 – 12 oz cans	9.65
13	Konbu	6	8	2 kg box	6
76	Lakkalikööri	23	1	500 ml	18
67	Laughing Lumberjack Lager	16	1	24 – 12 oz bottles	14
74	Longlife Tofu	4	7	5 kg pkg.	10
65	Louisiana Fiery Hot Pepper Sauce	2	2	32 – 8 oz bottles	21.05
66	Louisiana Hot Spiced Okra	2	2	24 – 8 oz jars	17
51	Manjimup Dried Apples	24	7	50 – 300 g pkgs.	53
32	Mascarpone Fabioli	14	4	24 – 200 g pkgs.	32
49	Maxilaku	23	3	24 – 50 g pkgs.	20
9	Mishi Kobe Niku	4	6	18 – 500 g pkgs.	97
72	Mozzarella di Giovanni	14	4	24 – 200 g pkgs.	34.8

참고

W3C School - SQL BETWEEN Keywords

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그

https://maz.kr

모든 포스트 보기

BETWEEN

예시

가격이 10과 20 사이인 모든 제품을 선택한다.

예의 범위를 벗어난 제품을 표시하려면 NOT BETWEEN을 사용

ProductName이 ‘Carnarvon Tigers’와 ‘Mozzarella di Giovanni’ 사이에 있는 모든 제품을 선택한다.

참고

댓글 답글 취소