SELECT MAX([_Index]), [ProjectNumber] FROM dbo.[transitions] WHERE [State] <> 4 AND [JobID] = '0000000009'GROUP BY ProjectNumber我知道WHERE 是作用在GROUP BY之前,但是我想WHERE 里的条件作用在GROUP BY之后怎么写语句,祈求大神帮忙!!