Selecting seperate fields from file - each based on different criteria

ricka360

We have a file with grade fields - each with a 'status' field which we would like to use as criteria for adding the the grade fields togather.
(ie. if status field for grade1 is 'A', add to sum, else bypass)

Thanks for your help
Rick

Delerna

use case when

for example, this will return the number of records that have Field1=0

Expand|Select|Wrap|Line Numbers

 
select sum(case when Field1=0 then 1 else 0 end as result

From TheTable

There are better ways to do that.
It servers to illustrate CASE WHEN

Selecting seperate fields from file - each based on different criteria

re: Selecting seperate fields from file - each based on different criteria

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about