楼上的好像不对,前两位是04,应该是用like "04%"吧 |
select teacherid,count(courseid) from timetable group by teacherid having count(courseid)>=4 |
|申请友链|小黑屋|Archiver|手机版|MySQL社区
( 京ICP备07012489号 )
联系人:周生; 联系电话:13911732319
GMT+8, 2024-6-17 21:42 , Processed in 0.064632 second(s), 27 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.