การใช้ BETWEEN ใน View
BETWEEN เลือกค่าในช่วง ใช้ร่วมกับ View ได้
ตัวอย่าง: ตาราง Student_info
mysql> SELECT * FROM Student_info;
+------+---------+------------+------------+
| id | Name | Address | Subject |
+------+---------+------------+------------+
| 101 | YashPal | Amritsar | History |
| 105 | Gaurav | Chandigarh | Literature |
| 125 | Raman | Shimla | Computers |
| 130 | Ram | Jhansi | Computers |
| 132 | Shyam | Chandigarh | Economics |
| 133 | Mohan | Delhi | Computers |
+------+---------+------------+------------+View 'Info' ชื่อระหว่าง 'C' ถึง 'P'
mysql> CREATE OR REPLACE VIEW Info AS
-> SELECT * FROM Student_info WHERE Name BETWEEN 'C' AND 'P';
Query OK, 0 rows affected (0.14 sec)
mysql> SELECT * FROM Info;
+------+--------+------------+------------+
| id | Name | Address | Subject |
+------+--------+------------+------------+
| 105 | Gaurav | Chandigarh | Literature |
| 133 | Mohan | Delhi | Computers |
+------+--------+------------+------------+ใช้ NOT BETWEEN เลือกนอกช่วง
mysql> CREATE OR REPLACE VIEW Info AS
-> SELECT * FROM Student_info WHERE Name NOT BETWEEN 'C' AND 'P';
Query OK, 0 rows affected (0.06 sec)
mysql> SELECT * FROM Info;
+------+---------+------------+-----------+
| id | Name | Address | Subject |
+------+---------+------------+-----------+
| 101 | YashPal | Amritsar | History |
| 125 | Raman | Shimla | Computers |
| 130 | Ram | Jhansi | Computers |
| 132 | Shyam | Chandigarh | Economics |
+------+---------+------------+-----------+BETWEEN รวมค่าขอบเขต NOT BETWEEN เลือกนอกช่วง
