sql查询不同用户某一天的最新记录

select  userId, result, max(dailyTime),studentbase.sclassId,collegeId,majorId
                        from dailycard, studentbase, collegemajorclass
                        where
                              dailycard.userId = studentbase.studentId and                 
                              studentbase.sclassId=collegemajorclass.sclassId
                              and DATE_FORMAT(dailyTime,'%Y-%m-%d') = '2022-06-04'
                              and collegemajorclass.collegeId=6
group by dailycard.userId;
           

MYSQL查询不用用户某一天的最新记录