[MySQL] 중복 데이터 하나만 표시하기

하나를하더라도최선을 2020-01-04 12:18:54 18,826 1 0

SELECT MIN(uid), app_name FROM g5_app_history GROUP BY app_name

댓글 1개

하

하나를하더라도최선을 2021-03-21 16:33:11

SELECT MAX(`uid`) AS uid, `problemNum`, `studentID`, `correct`, `PaperNum`, `teacherID` FROM `test_result` WHERE `problemNum` = '2281' GROUP BY `problemNum` ORDER BY `uid` DESC