|
主题:请教高手这两个SQL查询有什么区别? [收藏主题] |
1、select top {$Param(0)} id,title,picurl from KS_Article where picnews=1 and recommend=1 and deltf=0 and verific=1 and tid in(select id from ks_class where ts like '%{$CurrClassID}%') order by id desc
2、select top {$Param(0)} id,title,picurl from KS_Article where picnews=1 and recommend=1 and deltf=0 and verific=1 and tid in({$CurrClassChildID}) order by id desc
3、select top {$Param(0)} id,title,picurl from KS_Article where picnews=1 and recommend=1 and deltf=0 and verific=1 where ts like '%{$CurrClassID}%') order by id desc
能否尽量说的详细些,非常感谢! |
|
支持(0) | 反对(0) 顶端 底部 |
<上一主题 | 下一主题 > |