22,207
社区成员
发帖
与我相关
我的任务
分享
Select Top 10 A.ID,A.TO_Name,A.TO_LabelLib
From [CNode_TableOne] A
Where A.TO_StateNum In (5,6)
And (select Count(ID)
From [CNode_TableOne]
Where TO_StateNum In (5,6)
And CharIndex(',31,',TO_LabelLib)>0)>0
And CharIndex(',31,',A.TO_LabelLib)>0
select top 10 * from
(select ID,TO_Name,TO_LabelLib From [CNode_TableOne] Where TO_StateNum In (5,6) And CharIndex(',31,',TO_LabelLib)>0)
CharIndex(',31,',TO_LabelLib)>0 Order By TO_ViewCount Desc,TO_PostTime Desc,ID Desc) a
Select Top 10 A.ID,A.TO_Name,A.TO_LabelLib From [CNode_TableOne] A
Where A.TO_StateNum In (5,6)
And
exists(select 1 From [CNode_TableOne] Where TO_StateNum In (5,6) And CharIndex(',31,',TO_LabelLib)>0
And
CharIndex(',31,',A.TO_LabelLib)>0
)
Order By A.TO_ViewCount Desc,A.TO_PostTime Desc,A.ID Desc
?if not exists(select ....)
insert............