以下查询返回最高值 dcr 和离开 fields。

Below query returns the highest value of dcr and leave fields.

SELECT [type], MAX(dcr) AS MaxOfDcr, MAX(leave) AS MaxOfLeave
FROM TableName
GROUP BY [type]

如果你想得到别的东西，请告诉我。

If you want to get something else, please let me know.

SELECT MAX(CountOfDcr) AS MaxCountOfDcr, MAX(CountOfLeave) AS MaxCountOfLeave
FROM(
    SELECT dcr, COUNT(dcr) AS CountOfDcr, leave, COUNT(leave) AS CountOfLeave
    FROM TableName
    GROUP BY dcr, leave
) AS T

[/ EDIT]

[/EDIT]