SELECT Statement

Query SELECT adalah perintah yang paling sering digunakan. Gunanya untuk mengambil data dari database.

Basic Syntax

sql

SELECT column1, column2 FROM table_name;

Example

Kita punya tabel products:

id	name	price	stock
1	Laptop	15000	5
2	Mouse	200	50
3	Keyboard	500	0

1. Select All Columns

Mengambil semua data menggunakan tanda bintang (*).

sql

SELECT * FROM products;

Output:

text

+----+----------+-------+-------+
| id | name     | price | stock |
+----+----------+-------+-------+
| 1  | Laptop   | 15000 | 5     |
| 2  | Mouse    | 200   | 50    |
| 3  | Keyboard | 500   | 0     |
+----+----------+-------+-------+

2. Select Specific Columns

Hanya mengambil kolom nama dan harga.

sql

SELECT name, price FROM products;

Output:

text

+----------+-------+
| name     | price |
+----------+-------+
| Laptop   | 15000 |
| Mouse    | 200   |
| Keyboard | 500   |
+----------+-------+