Beranda > SQL > Contoh Operator Logika di SQL

Contoh Operator Logika di SQL

Oleh Nur Ardiansyah Posting Komentar

Contoh dibawah ini menggunakan tabel CUSTOMER yang sudah dibuat sebelumnya:

SELECT * FROM TB_CUSTOMERS;

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  2 | Michel    |       24 | Jakarta      |   2000 |
|  3 | Samuel    |       30 | Surabaya     |   6500 |
|  4 | Johan     |       27 | Jogjakarta   |   2000 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  6 | Samsul    |       35 | Makasar      |   5000 |
|  7 | Sandi     |       24 | Bandung      |   9000 |
+----+-----------+----------+--------------+--------+
7 rows in set (0.002 sec)
Berikut adalah beberapa contoh sederhana yang menunjukan penggunaan Operator Logika di SQL -

Contoh 1

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST >27 AND SALARY >=6500;

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  3 | Samuel    |       30 | Surabaya     |   6500 |
+----+-----------+----------+--------------+--------+
2 rows in set (0.001 sec)

Contoh 2

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST >30 OR SALARY >=6500;

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  3 | Samuel    |       30 | Surabaya     |   6500 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  6 | Samsul    |       35 | Makasar      |   5000 |
|  7 | Sandi     |       24 | Bandung      |   9000 |
+----+-----------+----------+--------------+--------+
5 rows in set (0.286 sec)

Contoh 3

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST IS NOT NULL;

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  2 | Michel    |       24 | Jakarta      |   2000 |
|  3 | Samuel    |       30 | Surabaya     |   6500 |
|  4 | Johan     |       27 | Jogjakarta   |   2000 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  6 | Samsul    |       35 | Makasar      |   5000 |
|  7 | Sandi     |       24 | Bandung      |   9000 |
+----+-----------+----------+--------------+--------+
7 rows in set (0.001 sec)

Contoh 4

SELECT * FROM TB_CUSTOMERS WHERE NAME_CUST LIKE '%DI%';

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  7 | Sandi     |       24 | Bandung      |   9000 |
+----+-----------+----------+--------------+--------+
3 rows in set (0.022 sec)

Contoh 5

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST IN (27,30);

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  3 | Samuel    |       30 | Surabaya     |   6500 |
|  4 | Johan     |       27 | Jogjakarta   |   2000 |
+----+-----------+----------+--------------+--------+
2 rows in set (0.001 sec)

Contoh 6

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST BETWEEN 24 AND 27;

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  2 | Michel    |       24 | Jakarta      |   2000 |
|  4 | Johan     |       27 | Jogjakarta   |   2000 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  7 | Sandi     |       24 | Bandung      |   9000 |
+----+-----------+----------+--------------+--------+
4 rows in set (0.020 sec)

Contoh 7

SELECT AGE_CUST FROM TB_CUSTOMERS WHERE EXISTS (SELECT AGE_CUST FROM TB_CUSTOMERS WHERE SALARY >9000);

Hasil

+----------+
| AGE_CUST |
+----------+
|       34 |
|       24 |
|       30 |
|       27 |
|       25 |
|       35 |
|       24 |
+----------+
7 rows in set (0.301 sec)

Contoh 8

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST > ALL (SELECT AGE_CUST FROM TB_CUSTOMERS WHERE SALARY > 9000);

Hasil

AGE_CUST FROM TB_CUSTOMERS WHERE SALARY > 9000);
+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  6 | Samsul    |       35 | Makasar      |   5000 |
+----+-----------+----------+--------------+--------+
1 row in set (0.052 sec)

Contoh 9

SELECT * FROM TB_CUSTOMERS WHERE AGE_CUST > ANY (SELECT AGE_CUST FROM TB_CUSTOMERS WHERE SALARY >6500);

Hasil

+----+-----------+----------+--------------+--------+
| id | name_cust | age_cust | address_cust | salary |
+----+-----------+----------+--------------+--------+
|  1 | Budi      |       34 | Bandung      |  15000 |
|  3 | Samuel    |       30 | Surabaya     |   6500 |
|  4 | Johan     |       27 | Jogjakarta   |   2000 |
|  5 | Dian      |       25 | Bandung      |   9000 |
|  6 | Samsul    |       35 | Makasar      |   5000 |
+----+-----------+----------+--------------+--------+
5 rows in set (0.001 sec)
Location:

Posting Komentar untuk "Contoh Operator Logika di SQL"