解决方案 »
- delphi 中 MyStoredProc存储过程 输出函数,
- mysql命令行无法登陆
- 请教个MYSQL命令,用来实现为原创
- 我为何在官方找不到mysql administrator 和 mysql query browser的下载呀?
- 循环向SQL数据库插入上万条记录,探讨其效率问题
- mysql查询语句怎么用上正则表达式?
- 求助如何访问内网的MySQL Server?
- 我是新手
- 什么错误信息,如何改正,mysql中create table错误
- ubuntu下修改my.cnf 二进制日志 ,启动失败
- 2张张表关联查询的问题,求大神解决
- mysql的表如何让用户名和酒店名转化为数字(都有重复)
order by 时间
order by 时间
from(
SELECT
`arrangement`.`projectid`,
`arrangement`.`courseid`,
`arrangement_date`.`date`,
SUM(CASE WHEN `arrangement`.`traindays`=0 THEN `arrangement`.`time` ELSE `arrangement`.`traindays` END) AS `usetime`,
GROUP_CONCAT(`teacher`.`name` ORDER BY `teacher`.`name` ASC) AS `teachername`
FROM
`arrangement`
INNER JOIN
`arrangement_date`
ON DATE(`arrangement_date`.`date`) BETWEEN DATE(`arrangement`.`startdate`) AND DATE(`arrangement`.`enddate`)
INNER JOIN
`teacher`
ON `teacher`.`id`=`arrangement`.`teacherid`
WHERE
DATE(`arrangement_date`.`date`) BETWEEN DATE('2015-1-1') AND date('2015-1-31')
GROUP BY
`arrangement`.`projectid`,`arrangement`.`courseid`, `arrangement_date`.`date`
) a
order by (select min(`date`) from (
SELECT
`arrangement`.`projectid`,
`arrangement`.`courseid`,
`arrangement_date`.`date`,
SUM(CASE WHEN `arrangement`.`traindays`=0 THEN `arrangement`.`time` ELSE `arrangement`.`traindays` END) AS `usetime`,
GROUP_CONCAT(`teacher`.`name` ORDER BY `teacher`.`name` ASC) AS `teachername`
FROM
`arrangement`
INNER JOIN
`arrangement_date`
ON DATE(`arrangement_date`.`date`) BETWEEN DATE(`arrangement`.`startdate`) AND DATE(`arrangement`.`enddate`)
INNER JOIN
`teacher`
ON `teacher`.`id`=`arrangement`.`teacherid`
WHERE
DATE(`arrangement_date`.`date`) BETWEEN DATE('2015-1-1') AND date('2015-1-31')
GROUP BY
`arrangement`.`projectid`,`arrangement`.`courseid`, `arrangement_date`.`date`
) b where projectid=a.projectid),a.projectid
) b where projectid=a.projectid),a.projectid,a.`date`