注册
找回密码
账号 记住
2149
2
282
0
从多个栏目中,每个栏目读取前2条文章
select top 2 id,title,url from ks_article where tid='栏目ID1',tid='栏目ID2',tid='栏目ID3'
这句语句错在哪里?正确的要怎么写?
请各位大虾指教啊
10439
18
select a.id,title from ks_article a where a.id in(select top 2 id from ks_article where id = a.id and tid in('栏目1','栏目2')) order by a.id desc
试试以上语句