tip_part_no as TIPPartNo, date_rec as DateRecieve, reciever_name as RecieverName,packing_list_no;("Select tip_part_no as TIP, SUM(qty) as Total_Quantity from pcba_info.lot_info
我想只选择一个列(Failed_operation)和distinct列(SN),如下代码所示,但我收到错误:列"rw_pcba.sn“必须出现在GROUP BY子句中或用于聚合函数中 我尝试在( SNcount(CASE WHEN (extract(day FROM NOW() - fail_timestamp)) <= 0 THEN 1 ELSE NULL END) AS Aging0
FROM rw_pcba
但显然我做错了什么,因为我犯了错误: #000: H5Dio.c line 271 in H5Dwritein H5D__pre_write(): can't write data minor: Write failed
#002: H5Dio.c line(FILE, H5F_ACC_TRUNC, H