SQLite - Group By语句

SELECT column-list
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2....columnN
ORDER BY column1, column2....columnN 

SELECT NAME, SUM(FEES) FROM STUDENT GROUP BY NAME;

INSERT INTO STUDENT VALUES (7, 'Ajeet', 27, 'Delhi', 10000.00 );
INSERT INTO STUDENT VALUES (8, 'Mark', 23, 'USA', 5000.00 );
INSERT INTO STUDENT VALUES (9, 'Mark', 23, 'USA', 9000.00 );

SELECT NAME, SUM(FEES) FROM STUDENT GROUP BY NAME ORDER BY NAME;

SELECT NAME, SUM(FEES) 
FROM STUDENT GROUP BY NAME ORDER BY NAME DESC;