下列那幾個是正確的 SQL 語法？
ASELECT * FROM Paper WHERE end-start>10;
BSELECT * FROM Paper WHERE end-start<0;
CSELECT SUM(title) FROM Paper;
DSELECT year,COUNT(*) FROM Paper GROUP BY year;
ESELECT year,COUNT(*) FROM Paper ORDER BY year;
答案與詳解
為什麼答案是 —
WHERE 子句中可對兩欄位做算術運算再比較，end-start>10 語法合法，代表篩選持續時間超過 10 的資料。
考點：WHERE 算術運算考點：WHERE 比較運算考點：聚合函數型別考點：GROUP BY 分組
載入中…
