SQL-complete-tutorial
13 строк · 218.0 Байт
1SELECT *
2FROM sql_store.customers
3WHERE phone IS NULL;
4
5SELECT *
6FROM sql_store.customers
7WHERE phone IS NOT NULL;
8
9-- Get the orders that are not shipped yet
10
11SELECT *
12FROM sql_store.orders
13WHERE shipped_date IS NULL;