我有一个查询,它根据审计日期提取报告,但我非常困惑的是,GROUP命令如何不能满足我对输出的期望。tblqualityaudit qua AND prd.fldstarttime=qua.fldprodstarttime+------------+--------------+---------------------
在mysql中使用view和group by时,我得到了错误的结果。一个简单的表test1 a 2003 b 1505 c 120select* from (select * from test order by name asc, value asc ) as test group by test.name;id name value2 a