一、SELECT * FROM XG_ATTENDANCE P ORDER BY P.XA_CLASSID,P.XA_TIME,P.XA_NODE,P.XA_ATTENDANCE_TYPE;
二、SELECT XA_CLASSID,XA_TIME,XA_NODE,XA_ATTENDANCE_TYPE,XA_STUDENTBASEID
FROM (SELECT P.XA_CLASSID,P.XA_TIME,P.XA_NODE,P.XA_ATTENDANCE_TYPE,wm_concat(P.XA_STUDENTBASEID)XA_STUDENTBASEID
FROM XG_ATTENDANCE P
GROUP BY P.XA_CLASSID,P.XA_TIME,P.XA_NODE,P.XA_ATTENDANCE_TYPE) S;