how can i sum subqueries data in sql server 2008?
how can i sum sub-queries data in sql server 2008?
In this query i want to sum this 'Score' column data in this CASE
Function, where point between rang of number, enough time i try to sum
this column it show me error. now i want to sum this column 'Score' With
Group by Applicant id, what's the way i can sum this 'Score' column data
together but i can't to do this query. please help me, here I'm a
beginner.
-------query----------------
SELECT ApplicantId,point,'Score'= CASE
WHEN point BETWEEN 4.00 AND 4.50 THEN ('3' )
WHEN point BETWEEN 3.5 AND 4.00 THEN ('2' )
END
FROM tblAcademicInfo
WHERE tblAcademicInfo.ApplicantId=tblAcademicInfo.ApplicantId
-----------Output---------------
ApplicantId point Score
xzc1 3.25 NULL
xzc1 4.36 3
xzc1 3.59 2
xzc1 4.00 3
No comments:
Post a Comment