SQL-选择语句

选择语句                                                                                                                      

SELECT *
-- *为选取所有列，可改为所求列名
FROM table
WHERE order = 1
ORDER BY id

​SELECT 
       name,
       points,
       (points + 10) * 10 AS discount
FROM customer
-- AS:取别名

WHERE语句

SELECT *
FROM orders
WHERE order-date >= '2019-01-01'
-- > >= < <= = {!= 或 <>}

 AND OR NOT 运算符

-- AND OR NOT---
SELECT *
FROM order_items
WHERE order_id = 6 AND unit_price * quantity > 30 
-- WHERE birth_date > '1990-01-01' OR (points > 1000 AND state = 'VA')
-- WHERE NOT (birth_date > '1990-01-01' OR points > 1000 AND state = 'VA')

IN 运算符

SELECT *
FROM customers
-- WHERE state = 'VA' OR state = 'GA' OR state = 'FL'
-- WHERE state='VA'OR'GA' 此写法错误
-- WHERE state IN ('VA','FL','GA')
WHERE state NOT IN ('VA','FL','GA')