How to encorporate IF

[dba112233]

How can I put an If statement saying If # RECORDS returned from the query below

IF # records returned is > 1 then
SUM(rmstranamt) AS rmstranamt10
ELSE

rmstranamt AS rmstranamt10

SELECT RMSFILENUM,
rmstranamt AS rmstranamt10 <-----If statement goes here base on if the amount of records found in select is >1 or not
FROM RFINANL
WHERE RMSTRANCDE = '10'
GROUP BY RMSFILENUM, rmstranamt
) AS rf10 ON rf10.RMSFILENUM = rm.RMSFILENUM

 

[dba112233]

I want to return sum(rmstranamt) AS rmstranamt10 in cases where the same query produces > 1 records

In other words if this:

SELECT RMSFILENUM,
rmstranamt AS rmstranamt10
FROM RFINANL
WHERE RMSTRANCDE = '10'
GROUP BY RMSFILENUM, rmstranamt

produces > 1 records, then I don't want to return rmstranamt AS rmstranamt10, I want to return sum(rmstranamt) AS rmstranamt10

 

[SQLSister]

You cannot use an if statment inside a select. Look up Case in BOL to see what to use instead.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief