Posted by Pradeep on 10/18/06 01:44

Hello,

In my table, I have two columns - ForecastSales and ActualSales. I need
to write a query that returns me just one aggregate value (one row and
one column). If sum(ActualSales - ForecastSales) is negative, I need to
return "red." Otherwise, I need to return green.

I looked at CASE statement. However, I could not figure out an
efficient way to build this query. I would appreciate your help.

Thank you in advance for your help.

Pradeep

• Next in forum: Re: Case Statement in Where Clause
• Prev in forum: sql statement to select customers contributing top 60% of sales
• Thread view: SQL statement to compare and return one aggregated value

[Reply to this message]