想建立一张视图 ,怎样 通过 判断Score 0-100 就是返回1 ,101-400 返回2, 401-1000返回3.......CREATE View UStatisticsAS
SELECT Id,[UserName],ClickTimes,HeadImage,RegistTime,Score,Hobby,
(SELECT Count(Id) FROM Answer WHERE UserId=UserInfo.Id) AS AnswerNumber,
(SELECT Count(ShareId) FROM Share WHERE UserId=UserInfo.Id) AS ShareNumber,
(SELECT Count(Id) FROM Messages WHERE ReUserId=UserInfo.Id) AS MessageNumber,
(SELECT CASE Score
WHEN (Score BETWEEN 0 AND 100) THEN '1' when(Score BETWEEN 101 AND 400) then '2' 等
END
FROM UserInfo WHERE Id=UserInfo.Id) AS Grade
FROM UserInfo
出现错误!
SELECT Id,[UserName],ClickTimes,HeadImage,RegistTime,Score,Hobby,
(SELECT Count(Id) FROM Answer WHERE UserId=UserInfo.Id) AS AnswerNumber,
(SELECT Count(ShareId) FROM Share WHERE UserId=UserInfo.Id) AS ShareNumber,
(SELECT Count(Id) FROM Messages WHERE ReUserId=UserInfo.Id) AS MessageNumber,
(SELECT CASE Score
WHEN (Score BETWEEN 0 AND 100) THEN '1' when(Score BETWEEN 101 AND 400) then '2' 等
END
FROM UserInfo WHERE Id=UserInfo.Id) AS Grade
FROM UserInfo
出现错误!
WHEN (Score BETWEEN 0 AND 100) THEN '1' when(Score BETWEEN 101 AND 400) then '2' 等
END 试下这个
select case score when 0 to 100 then 1 case 101 to 400 then 2....
关键字 'To' 附近有语法错误。还是有错误啊!