azhe127

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::

先上查询语句:

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

 

查询结果:

实际效果:

当前查询的产品是:新一代财务软件普及版,

页面最下方是相关产品

网址链接:

posted on 2013-11-26 18:04  azhe127  阅读(250)  评论(0编辑  收藏  举报