If you want to get
MAX
value for single date, try this:
SELECT E_date, MAX(TPaidAmt)
FROM Vw_PaymentDetails
GROUP BY E_date
But, if you want to get
MAX
value for
SUM(of Amount)
, try this:
SELECT E_date, MAX(AmtSUM) AS MaxOfAmtSum
FROM (
SELECT E_date, UM(TPaidAmt) AS AmtSUM
FROM Vw_PaymentDetails
GROUP BY E_date
) AS T