先上查询语句:
select top 8 * from
(select 1 as [id],[title],file_path,[image] from [article] where ArticleType=2 and id<>952 and pid=(select top 1 pid from [article] where ArticleType=2 and id=952) and view_yes=1 union all select top 8 2 as [id],[title],file_path,[image] from [article] where ArticleType=2 and id<>952 and pid<>(select top 1 pid from [article] where ArticleType=2 and id=952) and view_yes=1) aa
查询结果:
实际效果:
当前查询的产品是:新一代财务软件普及版,
页面最下方是相关产品
网址链接: