今天用JAVA做选课系统,结果用group by从数据库选出来的数据一直不全,语句如下:select student.studentID,age,major,studentName,eMail,phone,sex,courseid from student,xuanke where xuanke.studentID = student.studentid group by xuanke.courseid;
group by courseid(按照课程号id排序);
后来把group by 改成了order by以后就好了,语句如下:select student.studentID,age,major,studentName,eMail,phone,sex,courseid from student,xuanke where xuanke.studentID = student.studentid order by xuanke.courseid;
group by 是按照你的规则分组,所以会去重,order by 是按照你的规则直接查,这是我的个人理解,如果有问题,劳烦指出,谢谢
MYsql语句group by和Oder by的区别
最新推荐文章于 2022-03-06 18:16:49 发布