Operator Between selain digunakan pada Select statement, Anda juga dapat menggunakannya pada Delete dan Update statement.
Sintak Dasar
Di bawah ini adalah sintak dasar penggunaan operator Between di MySQL:
SELECT column_name1, column_name2, ..., column_name3 WHERE column_name1 [NOT] BETWEEN start_range AND end_range;
Contoh
Asumsikan Anda telah memiliki sebuah table "tbl_pegawai" dengan data-data sebagai berikut:
mysql> SELECT * FROM tbl_pegawai; +------------+------------------+---------------+----------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+----------+------------+------------+ | 1 | Nursalim | L | 1000000 | Brebes | IT | | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 4 | Achmad Fathoni | L | 3000000 | Batang | IT | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 7 | Dodi Al Farizi | L | 3000000 | Kendal | FIN | | 8 | Susanto | L | 4500000 | Cilacap | MKT | | 9 | Susanti | P | 43500000 | Banyumas | MKT | | 10 | Doni Nugroho | L | 3750000 | Pemalang | HRD | +------------+------------------+---------------+----------+------------+------------+ 10 rows in set (0.00 sec)Dari data diatas,
- Tampilkan data pegawai yang memiliki jangkauan id pegawai dari nomor 1 sampai dengan 7
mysql> SELECT * FROM tbl_pegawai -> WHERE id_pegawai BETWEEN 1 AND 7; +------------+------------------+---------------+---------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+---------+------------+------------+ | 1 | Nursalim | L | 1000000 | Brebes | IT | | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 4 | Achmad Fathoni | L | 3000000 | Batang | IT | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 7 | Dodi Al Farizi | L | 3000000 | Kendal | FIN | +------------+------------------+---------------+---------+------------+------------+ 7 rows in set (0.04 sec)
- Tampilkan data pegawai yang memiliki gaji dari Rp 3.000.000,- sampai dengan Rp 4.000.000,-
mysql> SELECT * FROM tbl_pegawai_backup -> WHERE gaji BETWEEN 3000000 AND 4000000; +------------+----------------+---------------+---------+----------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+----------------+---------------+---------+----------+------------+ | 4 | Achmad Fathoni | L | 3000000 | Batang | IT | | 6 | Iskiyati | P | 3000000 | Semarang | ACC | | 7 | Dodi Al Farizi | L | 3000000 | Kendal | FIN | | 10 | Doni Nugroho | L | 3750000 | Pemalang | HRD | +------------+----------------+---------------+---------+----------+------------+ 4 rows in set (0.00 sec)
- Tampilkan data pegawai yang memiliki gaji diluar Rp 3.000.000,- sampai dengan Rp 4.000.000,-
mysql> SELECT * FROM tbl_pegawai_backup -> WHERE gaji NOT BETWEEN 3000000 AND 4000000; +------------+------------------+---------------+----------+------------+------------+ | id_pegawai | nama_pegawai | jenis_kelamin | gaji | alamat | departemen | +------------+------------------+---------------+----------+------------+------------+ | 1 | Nursalim | L | 1000000 | Brebes | IT | | 2 | Naura Krasiva | P | 1500000 | Tegal | FIN | | 3 | Nurul Anawariyah | P | 2000000 | Pemalang | HRD | | 5 | Nurul Hikmah | P | 9000000 | Pekalongan | DIR | | 8 | Susanto | L | 4500000 | Cilacap | MKT | | 9 | Susanti | P | 43500000 | Banyumas | MKT | +------------+------------------+---------------+----------+------------+------------+ 6 rows in set (0.00 sec)
Sekian tutorial singkat tentang Cara Menggunakan Operator Between Di MySQL. Semoga bermanfaat & Happy Learning MySQL.
Salam,
Nursalim
No comments:
Post a Comment