【急】求sql语句，要求见内容。

2013-10-23 03:45:29 578 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【探秘】二维异形件重叠移除算法：从度量到消除的实战解析本文深入解析二维异形件重叠移除算法的核心技术与实战应用，涵盖重叠度量、零件扰动策略及消除方法。通过NFP（临界多边形）技术、空间分区加速等优化手段，有效解决异形件排版中的重叠问题，提升材料利用率和计算效率。适合制造业、CAD软件开发者及算法工程师参考。阅读详情

有这样一个表

对字段‘statetime’进行分组查询，如图

得到如下结果

但是我最终想得到的结果是在分组后每组取出前两条数据，并且实现翻页，用sql语句。数据库是sql2000的。

ps：只有80分了,你懂的，大神...

...全文

tiktok算法协议研究经过上述分析，可以确定目标字符串来源于一段 JSON 数据，而这段 JSON 数据来自于一个经过加密的本地文件。对字符串 "sdi_v2" 进行 SHA-1 计算，得到 20 字节的结果；将第一步得到的数据进行MD5计算，生成16字节的结果；将第二步的结果转换为十六进制字符串，从而得到 32 字节的密钥。写这种算法分析的帖子真的是太无聊了，就先分析到这里吧，后续有机会再来谈下被加密的本地文件是怎么来的！！自我感觉TT的算法并不难，就是量太大了，所以我想问问有没有感兴趣的朋友来一起分析，欢迎联系。阅读详情

qq330596595

应用实例 27,579 成员 68,540 内容

+ 关注 + 加入社区

切换为时间正序

LongRui888 2013-11-08

打赏
举报

对了，你再试试运行下面的代码，我加了一个排序的，然后把结果截图，贴出来，看看：


select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime,
       rownum
from
(
	select t1.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc,rownum

LongRui888 2013-11-08

打赏
举报

哦，明白了。那照理，刚才的代码，应该是可以的，返回statetime时间相同的数据中，的前两行，关键是没数据：

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi, newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo, newspage,userid,StateTime, rownum from ( select t1.*, ( select count(*) from ( select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi, newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo, newspage,userid,StateTime from tb_News where (NewsType = '时光树') and (userid = 1) group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType, NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort, newspartinfo,newspage,userid ) t2 where t2.StartTime = t1.StartTime and t2.NewsId <= t1.NewsId ) as rownum from ( select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi, newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo, newspage,userid,StateTime from tb_News where (NewsType = '时光树') and (userid = 1) group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType, NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort, newspartinfo,newspage,userid )t1 )t where rownum <= 2 order by StateTime desc,rownum

qq330596595 2013-11-08

打赏
举报

引用 16 楼 yupeigu 的回复:

试试这个呢，用了临时表：





if object_id('tempdb..#temp') is not null

   drop table #temp

   

   

--先放到临时表

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,

	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,

	   newspage,userid,StateTime,identity(int,1,1) as identity_id

	   into #temp

from tb_News

where (NewsType = '时光树') and (userid = 1)

group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,

		 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,

		 newspartinfo,newspage,userid





--查询结果

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,

	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,

	   newspage,userid,StateTime

from 

(

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,

	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,

	   newspage,userid,StateTime,

	   

	   (select count(*)

	    from #temp t2

	    where t1.StateTime = t2.StateTime

	          and t1.identity_id >= t2.identity_id) as rownum



from #temp t1

)t

where rownum <=2

order by StateTime desc,rownum

大哥，我是sql2000的数据库啊，刚才用这个sql的时候，报错说“查询设计器不支持 DROP TABLE SQL 构造。”

点击确认后又报了这个错误

，然后没有结果返回

LongRui888 2013-11-08

打赏
举报

试试这个呢，用了临时表：



if object_id('tempdb..#temp') is not null
   drop table #temp
   
   
--先放到临时表
select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
	   newspage,userid,StateTime,identity(int,1,1) as identity_id
	   into #temp
from tb_News
where (NewsType = '时光树') and (userid = 1)
group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
		 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
		 newspartinfo,newspage,userid


--查询结果
select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
	   newspage,userid,StateTime
from 
(
select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
	   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
	   newspage,userid,StateTime,
	   
	   (select count(*)
	    from #temp t2
	    where t1.StateTime = t2.StateTime
	          and t1.identity_id >= t2.identity_id) as rownum

from #temp t1
)t
where rownum <=2
order by StateTime desc,rownum

qq330596595 2013-11-08

打赏
举报

引用 14 楼 yupeigu 的回复:

[quote=引用 13 楼 qq330596595 的回复:] [quote=引用 12 楼 yupeigu 的回复:] [quote=引用 11 楼 qq330596595 的回复:] [quote=引用 4 楼 yupeigu 的回复:] 楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

是的，就是这个意思[/quote] 你试试这个：


select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select a.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

[/quote]报错了“列前缀‘a’与查询中所用的表名或列名不匹配”。[/quote] 改成这样试试：




select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select t1.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

[/quote]这样的结果是查询出了这个人所有信息，不是分组后的头两条数据

LongRui888 2013-11-08

打赏
举报

引用 13 楼 qq330596595 的回复:

[quote=引用 12 楼 yupeigu 的回复:] [quote=引用 11 楼 qq330596595 的回复:] [quote=引用 4 楼 yupeigu 的回复:] 楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

是的，就是这个意思[/quote] 你试试这个：


select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select a.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

[/quote]报错了“列前缀‘a’与查询中所用的表名或列名不匹配”。[/quote] 改成这样试试：




select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select t1.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

qq330596595 2013-11-08

打赏
举报

引用 12 楼 yupeigu 的回复:

[quote=引用 11 楼 qq330596595 的回复:] [quote=引用 4 楼 yupeigu 的回复:] 楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

是的，就是这个意思[/quote] 你试试这个：


select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select a.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

[/quote]报错了“列前缀‘a’与查询中所用的表名或列名不匹配”。

LongRui888 2013-11-08

打赏
举报

引用 11 楼 qq330596595 的回复:

[quote=引用 4 楼 yupeigu 的回复:] 楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

是的，就是这个意思[/quote] 你试试这个：


select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime
from
(
	select a.*,
		   (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.StartTime = t1.StartTime
					  and t2.NewsId <= t1.NewsId
		   ) as rownum
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by StateTime desc

qq330596595 2013-11-08

打赏
举报

引用 4 楼 yupeigu 的回复:

楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

是的，就是这个意思

qq330596595 2013-11-08

打赏
举报

引用 2 楼 ap0405140 的回复:

LZ最好能把SQL语句弄成文字的,以便修改.

是说列名吗

LongRui888 2013-11-08

打赏
举报

这个改一下：




select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
       newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
       newspage,userid,StateTime,
       rownum
from
(
	select t1.*,
	       (    
		        select count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime,
						   convert(varchar(7),StateTime,120) as mon
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.mon = t1.mon
		   )-	
		   (    
		        select 
		               count(*) 
				from 
				(
					select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
						   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
						   newspage,userid,StateTime,
						   convert(varchar(7),StateTime,120) as mon
					from tb_News
					where (NewsType = '时光树') and (userid = 1)
					group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
							 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
							 newspartinfo,newspage,userid
				) t2
				where t2.mon = t1.mon
					  and t2.NewsId <= t1.NewsId
		   )+1 as rownum 
	from
	(
		select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
			   newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
			   newspage,userid,StateTime,convert(varchar(7),StateTime,120) as mon
		from tb_News
		where (NewsType = '时光树') and (userid = 1)
		group by StateTime,NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,
				 NewsAudi,newstc,Newssource,updateuser,Newsimg,Statetype,psort,
				 newspartinfo,newspage,userid
	)t1
)t
where rownum <= 2
order by mon desc,StateTime desc,rownum

qq330596595 2013-11-08

打赏
举报

引用 36 楼 guoren12 的回复:

[quote=引用 34 楼 qq330596595 的回复:] [quote=引用 32 楼 guoren12 的回复:] [quote=引用 31 楼 qq330596595 的回复:] [quote=引用 30 楼 guoren12 的回复:]
SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)
这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
               newspage,userid,StateTime
        from tb_News as t
        where (NewsType = '时光树') and (userid = 1) and s.NewsId IN
        (select top 2 NewsId
        from tb_News 
        where t.StateTime=[StateTime],
              t.NewsId=[NewsId],
              t.NewsTitle=[NewsTitle],
              t.NewsContent=[NewsContent],
              t.NewsTime=[NewsTime],
              t.NewsClick=[NewsClick],
              t.NewsType=[NewsType],
              t.NewsAudi=[NewsAudi],
              t.newstc=[newstc],
              t.Newssource=[Newssource],
              t.updateuser=[updateuser],
              t.Newsimg=[Newsimg],
              t.Statetype=[Statetype],
              t.psort=[psort],
              t.newspartinfo=[newspartinfo],
              t.newspage=[newspage],
              t.userid=[userid]
              ORDER BY [StateTime])

你试试这个行不行[/quote]我用的是sql2000哦，

报错了[/quote]额，水平有限，我只能帮这么多了= =我的是08[/quote]恩恩，没事，谢谢你帮助了我

decamincow 2013-11-08

打赏
举报

引用 34 楼 qq330596595 的回复:

[quote=引用 32 楼 guoren12 的回复:] [quote=引用 31 楼 qq330596595 的回复:] [quote=引用 30 楼 guoren12 的回复:]
SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)
这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
               newspage,userid,StateTime
        from tb_News as t
        where (NewsType = '时光树') and (userid = 1) and s.NewsId IN
        (select top 2 NewsId
        from tb_News 
        where t.StateTime=[StateTime],
              t.NewsId=[NewsId],
              t.NewsTitle=[NewsTitle],
              t.NewsContent=[NewsContent],
              t.NewsTime=[NewsTime],
              t.NewsClick=[NewsClick],
              t.NewsType=[NewsType],
              t.NewsAudi=[NewsAudi],
              t.newstc=[newstc],
              t.Newssource=[Newssource],
              t.updateuser=[updateuser],
              t.Newsimg=[Newsimg],
              t.Statetype=[Statetype],
              t.psort=[psort],
              t.newspartinfo=[newspartinfo],
              t.newspage=[newspage],
              t.userid=[userid]
              ORDER BY [StateTime])

你试试这个行不行[/quote]我用的是sql2000哦，

报错了[/quote]额，水平有限，我只能帮这么多了= =我的是08

LongRui888 2013-11-08

打赏
举报

引用 29 楼 qq330596595 的回复:

[quote=引用 26 楼 yupeigu 的回复:] [quote=引用 25 楼 qq330596595 的回复:] [quote=引用 4 楼 yupeigu 的回复:] 楼主的意思，是不是把你写的语句的查询结果，再按照starttime字段来分组，每个组返回2条数据

嗯，这个是好的，谢谢了。你好厉害，我们可不可以加qq啊，我想拜你为师，学习sql。可以吗？ [/quote] 嗯我加你关注吧，你也加我关注，然后就给我发私信[/quote]恩恩，已经加关注，但是我还有个问题不明白啊，师傅。先看这两图

这个是查询所有的结果；下面是刚才那个sql的结果

按照月份分组取出头两条的话，2013年10月份的数据取出头两条后应该是2013/10/29和2013/10/26啊，为什么结果是2013/10/25和2013/10/9呢？[/quote] 哦，明白了，这个还得修改一下。

qq330596595 2013-11-08

打赏
举报

引用 32 楼 guoren12 的回复:

[quote=引用 31 楼 qq330596595 的回复:]
[quote=引用 30 楼 guoren12 的回复:]
SELECT * FROM tb_News AS t

WHERE t.StartDate IN

(SELECT TOP 2 StartDate

 FROM tb_News

 WHERE t.statetime=[statetime]  --分组的对象

 ORDER BY StartDate DESC)
这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,

               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,

               newspage,userid,StateTime

        from tb_News as t

        where (NewsType = '时光树') and (userid = 1) and s.NewsId IN

        (select top 2 NewsId

        from tb_News 

        where t.StateTime=[StateTime],

              t.NewsId=[NewsId],

              t.NewsTitle=[NewsTitle],

              t.NewsContent=[NewsContent],

              t.NewsTime=[NewsTime],

              t.NewsClick=[NewsClick],

              t.NewsType=[NewsType],

              t.NewsAudi=[NewsAudi],

              t.newstc=[newstc],

              t.Newssource=[Newssource],

              t.updateuser=[updateuser],

              t.Newsimg=[Newsimg],

              t.Statetype=[Statetype],

              t.psort=[psort],

              t.newspartinfo=[newspartinfo],

              t.newspage=[newspage],

              t.userid=[userid]

              ORDER BY [StateTime])

你试试这个行不行[/quote]我用的是sql2000哦，

报错了

decamincow 2013-11-08

打赏
举报

引用 32 楼 guoren12 的回复:

[quote=引用 31 楼 qq330596595 的回复:] [quote=引用 30 楼 guoren12 的回复:]
SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)
这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
               newspage,userid,StateTime
        from tb_News as t
        where (NewsType = '时光树') and (userid = 1) and t.NewsId IN
        (select top 2 NewsId
        from tb_News 
        where t.StateTime=[StateTime],
              t.NewsId=[NewsId],
              t.NewsTitle=[NewsTitle],
              t.NewsContent=[NewsContent],
              t.NewsTime=[NewsTime],
              t.NewsClick=[NewsClick],
              t.NewsType=[NewsType],
              t.NewsAudi=[NewsAudi],
              t.newstc=[newstc],
              t.Newssource=[Newssource],
              t.updateuser=[updateuser],
              t.Newsimg=[Newsimg],
              t.Statetype=[Statetype],
              t.psort=[psort],
              t.newspartinfo=[newspartinfo],
              t.newspage=[newspage],
              t.userid=[userid]
              ORDER BY [StateTime])

你试试这个行不行[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
               newspage,userid,StateTime
        from tb_News as t
        where (NewsType = '时光树') and (userid = 1) and t.NewsId IN
        (select top 2 NewsId
        from tb_News 
        where t.StateTime=[StateTime],
              t.NewsId=[NewsId],
              t.NewsTitle=[NewsTitle],
              t.NewsContent=[NewsContent],
              t.NewsTime=[NewsTime],
              t.NewsClick=[NewsClick],
              t.NewsType=[NewsType],
              t.NewsAudi=[NewsAudi],
              t.newstc=[newstc],
              t.Newssource=[Newssource],
              t.updateuser=[updateuser],
              t.Newsimg=[Newsimg],
              t.Statetype=[Statetype],
              t.psort=[psort],
              t.newspartinfo=[newspartinfo],
              t.newspage=[newspage],
              t.userid=[userid]
              ORDER BY [StateTime])

decamincow 2013-11-08

打赏
举报

引用 31 楼 qq330596595 的回复:

[quote=引用 30 楼 guoren12 的回复:]
SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)
这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊[/quote]

select NewsId,NewsTitle,NewsContent,NewsTime,NewsClick,NewsType,NewsAudi,
               newstc,Newssource,updateuser,Newsimg,Statetype,psort,newspartinfo,
               newspage,userid,StateTime
        from tb_News as t
        where (NewsType = '时光树') and (userid = 1) and s.NewsId IN
        (select top 2 NewsId
        from tb_News 
        where t.StateTime=[StateTime],
              t.NewsId=[NewsId],
              t.NewsTitle=[NewsTitle],
              t.NewsContent=[NewsContent],
              t.NewsTime=[NewsTime],
              t.NewsClick=[NewsClick],
              t.NewsType=[NewsType],
              t.NewsAudi=[NewsAudi],
              t.newstc=[newstc],
              t.Newssource=[Newssource],
              t.updateuser=[updateuser],
              t.Newsimg=[Newsimg],
              t.Statetype=[Statetype],
              t.psort=[psort],
              t.newspartinfo=[newspartinfo],
              t.newspage=[newspage],
              t.userid=[userid]
              ORDER BY [StateTime])

你试试这个行不行

qq330596595 2013-11-08

打赏
举报

引用 30 楼 guoren12 的回复:

SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)

这个简单的语句可以帮你做分组top2，试试吧。

不太明白这个sql，表中没有StartDate这个字段啊

decamincow 2013-11-08

打赏
举报

SELECT * FROM tb_News AS t
WHERE t.StartDate IN
(SELECT TOP 2 StartDate
 FROM tb_News
 WHERE t.statetime=[statetime]  --分组的对象
 ORDER BY StartDate DESC)

这个简单的语句可以帮你做分组top2，试试吧。

qq330596595 2013-11-08

打赏
举报

引用 26 楼 yupeigu 的回复:

[quote=引用 25 楼 qq330596595 的回复:]
[quote=引用 4 楼 yupeigu 的回复:]
楼主的意思，是不是把你写的语句的查询结果，

再按照starttime字段来分组，每个组返回2条数据

嗯，这个是好的，谢谢了。你好厉害，我们可不可以加qq啊，我想拜你为师，学习sql。可以吗？
[/quote]

嗯我加你关注吧，你也加我关注，然后就给我发私信[/quote]恩恩，已经加关注，但是我还有个问题不明白啊，师傅。先看这两图

这个是查询所有的结果；下面是刚才那个sql的结果

按照月份分组取出头两条的话，2013年10月份的数据取出头两条后应该是2013/10/29和2013/10/26啊，为什么结果是2013/10/25和2013/10/9呢？

加载更多回复（18）

【急】求sql语句，要求见内容。

相关推荐