β» μ΄ κΈμ μ½λνλ μ 체νλ¨ νλμ νλ©΄μ λ§λ€μ΄μ‘μ΅λλ€.
β» μ²μ μμνλ SQL νλ‘κ·Έλλ° κ°μμ
λλ€.
β» μ½λνλ μ λ°λ‘κ°κΈ°
SQL λͺ λ Ήμ΄λ₯Ό μ΄μ©ν λ°μ΄ν°μ μ‘°ν
select *
from orderItem
order by order_num ASC, quantity DESC;
select *
from products
order by prod_price DESC limit 3;
select *
from customers
where cust_state in ('MI','OH');
select *
from orders
where order_num between 20006 and 20008;
select *
from vendors
where vend_name like 'B%';
select distinct
vend_country
from vendors;
select *
from customers
where cust_country is null;
select cust_name as customerName
from customers;