i want paymentamount column in desc order

Hi try using order by SUM(PaymentAmount) desc

 

DECLARE @EffectivedtFrom AS DATETIME;
DECLARE @EffectivedtTo AS DATETIME;

SELECT @EffectivedtTo = MAX(EffectiveDate)
FROM claimsheader;

SELECT @EffectivedtFrom = DATEADD(mm, DATEDIFF(mm, 0, DATEADD(mm, - 11, @EffectivedtTo)), 0);

--,Dense_Rank() OVER ( ORDER BY (select 1 )) AS Number
SELECT HICN
,max(PatientName) AS PatientName
,MAX(practicename) practicename
,MAX(Deceased) Deceased
,MAX(ESDR) ESDR
,MAX(Cancer) Cancer
,MAX(Hospice) Hospice
,SUM(PaymentAmount) PaymentAmount
,MAX(EffectiveDate) EffectiveDate
,MAX(Number) Number
FROM (
SELECT vw.HICN
,vw.Firstname + ' ' + vw.lastname AS PatientName
,vw.practice practicename
,CASE
WHEN (
d.DateOfDeath IS NULL
OR d.DateOfDeath = ''
)
THEN 'No'
ELSE 'Yes'
END AS Deceased
,CASE
WHEN d.MedicareStatusCode IN (
11
,21
,31
)
THEN 'Yes'
ELSE 'No'
END AS ESDR
,CASE
WHEN b.HCC IN (
11
,9
,10
,12
,8
)
THEN 'Yes'
ELSE 'No'
END AS Cancer
,
--case when (d.DateBenEnrolledInHospice is null or d.DateOfDeath ='') then 'No'
CASE
WHEN (
d.DateBenEnrolledInHospice IS NULL
OR d.DateBenEnrolledInHospice = ''
OR cast(DateBenEnrolledInHospice AS DATETIME) NOT BETWEEN @EffectivedtFrom
AND @EffectivedtTo
)
THEN 'No'
ELSE 'Yes'
END AS Hospice
,cast(vw.PaymentAmount AS FLOAT) AS PaymentAmount
,vw.EffectiveDate
,Dense_Rank() OVER (
ORDER BY (
SELECT vw.HICN
)
) AS Number
FROM vwExpenditureDetails vw
INNER JOIN (
SELECT *
FROM demographics aa
WHERE aa.DemographicsID IN (
SELECT max(DemographicsID)
FROM demographics
GROUP BY hicn
)
) d ON vw.HICN = d.HICN
LEFT OUTER JOIN icdhcc b ON vw.PrincipalDiagnosisCode = b.ICD
WHERE cast(vw.EffectiveDate AS DATETIME) BETWEEN @EffectivedtFrom
AND @EffectivedtTo
AND vw.TaxID = @TIN
) aa
WHERE aa.Number BETWEEN 1
AND 500
GROUP BY HICN
order by SUM(PaymentAmount) desc