select teacher,class,subject, datediff(minute,starttime,endtime) as hoursum
from tmclassroomclass
group by teacher 出错
去掉 group by teacher 就对了
那位朋友能帮忙 看看sql应该怎么写 谢谢!!!
...全文
1008打赏收藏
关于分组!
select teacher,class,subject, datediff(minute,starttime,endtime) as hoursum from tmclassroomclass group by teacher 出错 去掉 group by teacher 就对了 那位朋友能帮忙 看看sql应该怎么写 谢谢!!!
select teacher,class,subject,datediff(minute,starttime,endtime) as hoursum
from tmclassroomclass
group by teacher,class,subject,datediff(minute,starttime,endtime)