SELECT MAX( table.Column),....
  FROM table.Name
  WHERE .......
  GROUP BY  分组规则