sql如何查询某列相同值对应另一列最大值

SELECT a, b, c ,(SELECT Max(c) FROM TableX WHERE b = B.b) AS d FROM TableX X