本文提供了一个SQL查询案例，展示了如何从UserInfo表中选择前100条记录，并通过CASE语句处理State和JoinState字段，生成usestate字段。该查询有助于理解SQL中的条件判断及数据筛选。
Select top 100 State,JoinState, (case when State=1 and Joinstate=0 then 2 when State=1 and JoinState=1 then 1 else 0 end) as usestate from UserInfoSelect top 100 State,JoinState, (case when State=1 and Joinstate=0 then 2 when State=1 and JoinState=1 then 1 else 0 end) as usestate from UserInfo转载于:https://www.cnblogs.com/hanguoji/archive/2007/12/24/1012244.html
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
