#9 Penggunaan BETWEEN Pada Mysql Query
DATABASE PART 9
BETWEEN
QUERY MYSQL
Contoh penggunaan BETWEEN
SELECT nama_kolom
FROM nama_tabel
WHERE nama_kolom BETWEEN data1 AND data2;
Pernyataan SQL berikut memilih semua data dengan nilai ANTARA 60 dan 80
SELECT * FROM `tbl_nilai` WHERE nilai BETWEEN 60 AND 80
Untuk menampilkan data di luar rentang nilai sebelumnya, gunakan TIDAK ANTARA(NOT BETWEEN):
SELECT nama_kolom
FROM nama_tabel
WHERE nama_kolom NOT BETWEEN data1 AND data2;
SELECT * FROM `tbl_nilai` WHERE nilai NOT BETWEEN 60 AND 80
SELECT * FROM `tbl_nilai` WHERE nilai NOT BETWEEN 60 AND 80 AND mata_kuliah ='Programming PHP'
Memanggil data dimana parameter(batasan) terdiri dari banyak data
SELECT nama_kolom
FROM nama_tabel
WHERE nama_kolom BETWEEN data1 AND data2
AND nama_kolom NOT IN (data1,data2,data3);
SELECT * FROM `tbl_nilai` WHERE nilai BETWEEN 60 AND 80 AND mata_kuliah NOT IN ('Programming PHP','Arduino') ORDER BY mata_kuliah
SELECT * FROM `tbl_nilai` WHERE nim BETWEEN 150000 AND 170000 ORDER BY mata_kuliah
SELECT * FROM `tbl_nilai` WHERE nama BETWEEN 'Anglina Sony' AND 'Joko' ORDER BY mata_kuliah
Link Video Belajar Query SQL:
• Select Insert Delete Update pada Query Mys...
Link Video Sebelumnya:
1. Select, Insert, Delete, Update : • Select Insert Delete Update pada Query Mys...
2. Select Distinct : • #2 Select Distinct pada Query SQL - Part 2
3. Query And, Or dan Not : • #3 Operator AND OR dan NOT pada SQL Query ...
4. Query Null Values : • #4 Null Value pada MySql Query - Part 4
5. Query Max dan Min : • #5 Operator Min dan Max pada Query MySql -...
6. Query Count : https://studio.youtube.com/video/Gycc...
7. Query LIKE : • #7 Operator LIKE pada Mysql Query - Part 7
8. Query IN : • #8 Operator IN pada Mysql Query - Part 8 SQL
Tags:
big query,
power query,
database adalah,
query adalah,
apa itu query,
arti query,
2 cara membuat query,
localhost/phpmyadmin,
codeigniter,