itmtsn
asked on
SQL: AVG of an alias
Hi,
We want to compute the average of the djsresult field and save that as a new column.
we're using:
,Case WHEN (txtResultName IS NULL OR txtResultName = 'Average Point Score') THEN intGradeTransposeValue ELSE txtresult END as djsresult
How do I then calculate an Average of the djsresult field and include it in the results table as a column.
Full code attached
icode.txt
We want to compute the average of the djsresult field and save that as a new column.
we're using:
,Case WHEN (txtResultName IS NULL OR txtResultName = 'Average Point Score') THEN intGradeTransposeValue ELSE txtresult END as djsresult
How do I then calculate an Average of the djsresult field and include it in the results table as a column.
Full code attached
icode.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.