日期期聚合函数及排序
ＳＱＬ语句如下：
Select Max(MMFWorkID),Max(TaskID),Max(MMFname),ModeL,sum(BeginWeight),sum(EndWeight),
sum(loss),sum(qty),max(batch),max(dept),max(editer),MAX(EDITDATE)
from MMFWork
Where 1=1 and TaskID like '%% '
and MMFName like '%% ' and Model like '%% '
and Batch like '%% ' Group by ModeL order by editdate desc
去掉order by editdate可以运行，但是我需要对日期进行排序，
提示editdate未包含在聚合函数中，也未在group子句中
[解决办法]
Select Max(MMFWorkID),Max(TaskID),Max(MMFname),ModeL,sum(BeginWeight),sum(EndWeight),
sum(loss),sum(qty),max(batch),max(dept),max(editer),MAX(EDITDATE)
from MMFWork
Where 1=1 and TaskID like '%% '
and MMFName like '%% ' and Model like '%% '
and Batch like '%% ' Group by ModeL order by MAX(EDITDATE) desc
[解决办法]
Select Max(MMFWorkID),Max(TaskID),Max(MMFname),ModeL,sum(BeginWeight),sum(EndWeight),
sum(loss),sum(qty),max(batch),max(dept),max(editer),MAX(EDITDATE) editdate1
from MMFWork
Where 1=1 and TaskID like '%% '
and MMFName like '%% ' and Model like '%% '
and Batch like '%% ' Group by ModeL order by editdate1 desc
