Tips Cara Memakai And Dan Or Clause Di Mysql
Pada tutorial MySQL kali ini, kita akan mencar ilmu wacana Cara Menggunakan AND dan OR Clause. AND dan OR merupakan salah satu operator logi...
https://tutorialcarapintar.blogspot.com/2019/02/tips-cara-memakai-and-dan-or-clause-di.html
mysql> SELECT * FROM employee -> WHERE gender = 'L' -> AND salary > 3000000; +-------------+---------------+--------+----------+---------+------------+ | employee_id | employee_name | gender | address | salary | departemen | +-------------+---------------+--------+----------+---------+------------+ | 003 | Ahmad | L | Semarang | 5000000 | ACC | +-------------+---------------+--------+----------+---------+------------+ 1 row in set (0.00 sec)
Untuk menampilkan sesuai dengan kriteria diatas, Anda sanggup memakai operator AND menyerupai query berikut ini:
mysql> SELECT * FROM employee -> WHERE gender = 'L' -> AND salary > 10000000; Empty set (0.00 sec)
Untuk menampilkan sesuai dengan kriteria diatas, Anda sanggup memakai operator OR menyerupai query berikut ini:
mysql> SELECT * FROM employee -> WHERE gender = 'P' -> OR salary > 3000000; +-------------+---------------+--------+----------+---------+------------+ | employee_id | employee_name | gender | address | salary | departemen | +-------------+---------------+--------+----------+---------+------------+ | 002 | Naura | P | Bandung | 2000000 | HRD | | 003 | Ahmad | L | Semarang | 5000000 | ACC | | 004 | Nani | P | Surabaya | 2500000 | FIN | | 005 | Nurul | P | Tegal | 4500000 | FIN | +-------------+---------------+--------+----------+---------+------------+ 4 rows in set (0.00 sec)
Untuk menampilkan sesuai dengan kriteria diatas, Anda sanggup memakai operator OR menyerupai query berikut ini:
mysql> SELECT * FROM employee -> WHERE gender = 'P' -> OR departemen = 'IT'; +-------------+---------------+--------+----------+---------+------------+ | employee_id | employee_name | gender | address | salary | departemen | +-------------+---------------+--------+----------+---------+------------+ | 001 | Nursalim | L | Jakarta | 3000000 | IT | | 002 | Naura | P | Bandung | 2000000 | HRD | | 004 | Nani | P | Surabaya | 2500000 | FIN | | 005 | Nurul | P | Tegal | 4500000 | FIN | +-------------+---------------+--------+----------+---------+------------+ 4 rows in set (0.00 sec)
