SQLiteMAX语句

SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions]; 

SELECT expression1, expression2, ... expression_n
MAX(aggregate_expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n; 

SELECT NAME, ADDRESS, MAX(FEES) AS "Highest FEES"
FROM STUDENT
WHERE ID <= 5
GROUP BY ADDRESS;