?? group_all.txt
字號:
SELECT SUBSTR(product_name, 1, 15) "Product",
SUM(quantity) "Total Sold",
AVG(quantity) "Average",
COUNT(quantity) "Transactions",
MIN(quantity) "Fewest",
MAX(quantity) "Most"
FROM plsql101_purchase
GROUP BY product_name
HAVING SUM(quantity) < 30;
SELECT SUBSTR(product_name, 1, 15) "Product",
SUM(quantity) "Total Sold",
AVG(quantity) "Average",
COUNT(quantity) "Transactions",
MIN(quantity) "Fewest",
MAX(quantity) "Most"
FROM plsql101_purchase
GROUP BY product_name
HAVING SUM(quantity) >= 100;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -