tdashenjibie 2019-09-09 15:29 采纳率: 0%
浏览 434
已结题

mysql数据库的group by问题

可执行sql:
SELECT
oc.cabinet_id objectId,
CONCAT_WS( '/', di.driver_name, ri.plate_number ) driver,
tcc.business_mode businessMode,
so.name subName,
cci.carteam_name affName,
oo.order_No orderNo,
oo.book_Space_No bookSpaceNo,
oc.cabinet_No cabinetNo,
oc.cabinet_Type conType,
oo.order_type orderType,
ss.dispatch_type dispatchType,
st.remark remark,
oo.address address,
date_format( cc.settlement_date, '%Y-%m' ) endDate,
date_format( cc.settlement_date, '%Y-%m-%d' ) settlementDate,
cc.cost_status costStatus,
sum( cc.pay_amount ) total
FROM
t_ord_cabinet_cost cc
LEFT JOIN t_ord_cabinet oc ON oc.cabinet_id = cc.cabinet_id
LEFT JOIN t_ord_order oo ON oo.order_id = oc.order_id
LEFT JOIN t_sch_task st ON st.cabinet_id = oc.cabinet_id
LEFT JOIN t_sch_schedule ss ON ss.id = st.schedule_id
LEFT JOIN t_car_carteam_info cci ON cci.carteam_id = ss.carteam_id
LEFT JOIN t_dri_driver_info di ON ss.driver_id = di.driver_info_id
LEFT JOIN t_car_trailer_info ri ON ss.trailer_id = ri.trailer_id
LEFT JOIN t_sys_org so ON so.org_code = oo.org_code
LEFT JOIN t_cus_customer tcc ON tcc.customer_id = cc.settlement_customer_id
LEFT JOIN sys_user_info us ON us.user_id = tcc.salesman_id
WHERE
cc.cost_status IN ( 0, 3 )
AND ( cc.settlement_date IS NOT NULL OR cc.settlement_date != '' )
AND cc.break_rule_state IN ( 0, 2 )
AND cc.cost_type_code IN ( '26', '2', '3', '8', '9', '10' )
AND ( cc.pay_amount != 0 AND cc.pay_amount IS NOT NULL )
AND so.LEVEL = 2
AND so.minimum_guarantee = 1
AND oo.order_status != 0
AND ss.schedule_status = 4
AND tcc.settle_accounts = 1
GROUP BY
objectId,
so.org_code,
cci.carteam_id,
endDate,
di.driver_info_id,
ri.plate_number,
oo.order_id,
ss.id,
st.id,
tcc.business_mode,
cc.cost_status,
date_format( cc.settlement_date, '%Y-%m-%d' )
ORDER BY
driver,
objectId,
orderNo,
bookSpaceNo,
dispatchType,
endDate DESC

不可执行sql:
SELECT
oc.cabinet_id objectId,
CONCAT_WS( '/', sc.driver_name, sc.plate_number ) driver,
sc.business_mode businessMode,
oo.`company_name` subName,
sc.carteam_name affName,
oo.order_No orderNo,
oo.book_Space_No bookSpaceNo,
oc.cabinet_No cabinetNo,
oc.cabinet_Type conType,
oo.order_type orderType,
sc.dispatch_type dispatchType,
sc.task_remark remark,
oo.address address,
date_format( cc.settlement_date, '%Y-%m' ) endDate,
date_format( cc.settlement_date, '%Y-%m-%d' ) settlementDate,
cc.cost_status costStatus,
sum( cc.pay_amount ) total 

FROM
t_ord_cabinet_cost cc
LEFT JOIN t_sett_cost sc ON cc.cabinet_cost_id = sc.cabinet_cost_id
LEFT JOIN t_ord_cabinet oc ON oc.cabinet_id = cc.cabinet_id
LEFT JOIN t_ord_order oo ON oo.order_id = oc.order_id
LEFT JOIN t_sys_org so ON oo.org_code = so.org_code
WHERE
cc.cost_status IN ( 0, 3 )
AND ( cc.settlement_date IS NOT NULL OR cc.settlement_date != '' )
AND cc.break_rule_state IN ( 0, 2 )
AND sc.cost_type_class IN ( 0, 1 )
AND ( cc.pay_amount != 0 AND cc.pay_amount IS NOT NULL )
AND so.LEVEL = 2
AND so.minimum_guarantee = 1
AND oo.order_status != 0
AND sc.schedule_status = 4
AND sc.settle_accounts = 1
GROUP BY
objectId,
so.org_code,
sc.carteam_id,
endDate,
sc.driver_info_id,
sc.plate_number,
oo.order_id,
-- ss.id,
-- st.id,
sc.business_mode,
cc.cost_status,
date_format( cc.settlement_date, '%Y-%m-%d' )
ORDER BY
driver,
objectId,
orderNo,
bookSpaceNo,
dispatchType,
endDate DESC

问题:为什么第一个sql语句可以执行,第二个sql语句不可执行?
  • 写回答

4条回答 默认 最新

  • Amo_lt 2019-09-09 16:20
    关注

    请问报错是什么,请帖出来一下

    评论

报告相同问题?

悬赏问题

  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 arduino控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题