SQL Commands Flashcards

Front

抽取數據

Back

SELECT…FROM

Front

篩選數據

Back

WHERE

Front

將數據分組

Back

GROUP BY

Front

加總.

Back

SUM( )

Front

將數據分組

Back

GROUP BY

Front

與聚合函数並用，篩選數據

Back

HAVING

Front

排序

Back

ORDER BY