取出5条热点新闻
USE [Publishing System ]
GO
/****** Object:? StoredProcedure [dbo].[proghot5newsselect]??? Script Date: 05/12/2010 12:47:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:??韩慧
-- Create date: 2010-4-18
-- Description:?取出5条热点新闻
-- =============================================
ALTER PROCEDURE [dbo].[proghot5newsselect]
?
AS
BEGIN
?select top 5 n.id,n.title,n.createtime ,c.name,c.id as caid,COUNT(com.id) as comcount
?from news n
?inner join category c on n.caid=c.id
?left join comment com on com.newsid=n.id
?group by n.id,n.title,n.createtime ,c.name,c.id
?order by comcount desc
END
