set rowcount 0 ---加这个declare @a int
declare @b int
set @a=3
set @b=0
set rowcount @a
select yewy,sum(jine) jine
into #11
from pf_ckthmx
group by yewy
order by jine desc
set rowcount @b
select * from #11
drop table #11
declare @b int
set @a=3
set @b=0
set rowcount @a
select yewy,sum(jine) jine
into #11
from pf_ckthmx
group by yewy
order by jine desc
set rowcount @b
select * from #11
drop table #11
declare @b int
set @b=0
set rowcount 1
select yewy,sum(jine) jine
into #11
from pf_ckthmx
group by yewy
order by jine desc
set rowcount @b
select * from #11
drop table #11
2004-12-08 陈小影 170.94
2004-12-08 陈小影 190.00
2004-12-09 陈小影 222.22
2004-12-09 陈小影 512.82
2004-12-20 陈小影 170.94
2005-01-05 88 128.21如果按上面的查询应该是:' 陈小影'.但是查出来就是'88'了
set @b=0
set rowcount 1
select yewy,sum(jine) jine
into #11
from pf_ckthmx
group by yewy
order by jine desc
set rowcount @b
select * from #11
drop table #11
---------------------------select yewy,sum(jine) jine
--into #11
from pf_ckthmx
group by yewy
order by jine desc结果是不一样的?
select yewy,sum(jine) jine
from pf_ckthmx
group by yewy
order by jine desc
如果这么写,查出来是:陈小影.
set @b=0
set rowcount 1
select yewy,sum(jine) jine
into #11
from pf_ckthmx
group by yewy
order by jine desc
set rowcount @b
select * from #11
drop table #11
---------------------------select yewy,sum(jine) jine
--into #11
from pf_ckthmx
group by yewy
order by jine desc结果是不一样的?我觉得是不是因为在into #11 的时候表#11将结果从新排列了,你可以在对#11表进行查询的时候加上Order关键字,再一次排序一下,即select * from #11 order by....
加以个 order by 试一试
2004-12-08 陈小影 170.94
2004-12-08 陈小影 190.00
2004-12-09 陈小影 222.22
2004-12-09 陈小影 512.82
2004-12-20 陈小影 170.94
2005-01-05 88 128.21表aa 结构如上
----------------------------------------------------------------------
查询一:
set rowcount 1
select yewy,sum(jine) jine
from aa
group by yewy
order by jine desc结果是:
yewy jine
陈小影 1266.92
----------------------------------
查询二:
declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
into #11
from aa
group by yewy
order by jine desc
set rowcount 0
select * from #11
drop table #11
结果是:
yewy jine
88 128.21
----------------------------------
查询三:
set rowcount 1
select yewy,sum(jine) jine
into #11
from aa
group by yewy
order by jine desc
set rowcount 0
select * from #11
drop table #11
结果是:
yewy jine
88 128.21
------------------------------------------------------------其中查询二多执行几次!就一条记录,不用order by!!!!!!
你怎么试的,
你试的查询2的结果是什么,把查询2多执行几次?这个问题 '小李铅笔刀' 也试了,就是有问题.
declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
into #11
from aa
group by yewy
order by jine desc
set rowcount 0
select * from #11
drop table #11 插入的到表#11的语句只有一条(因为设置了set rowcount 1),而且是按jine倒序排列的.
结果就应该是 陈小影 1266.92
但查出的结果是 88 128.21
(请重复执行查询二)
insert into aa
select 2004-12-08,N'陈小影',170.94
union
select 2004-12-08,N'陈小影',190.00
union
select 2004-12-09,N'陈小影',222.22
union
select 2004-12-09,N'陈小影',512.82
union
select 2004-12-20,N'陈小影',170.94
union
select 2005-01-05,'88',128.21declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
into #11
from aa
group by yewy
order by jine desc
set rowcount 0
select * from #11
drop table #11
drop table aa
declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
from aa
group by yewy
order by jine desc
这个问题,'小李铅笔刀'也测试的,确实有问题?
再说我也没有必要骗你?我还要给经理答复呢??
那结果业务员肯定是:'陈小影'.不知你是怎么测的.
insert into aa
select 2004-12-08,N'陈小影',170.94
union
select 2004-12-08,N'陈小影',190.00
union
select 2004-12-09,N'陈小影',222.22
union
select 2004-12-09,N'陈小影',512.82
union
select 2004-12-20,N'陈小影',170.94
union
select 2005-01-05,'88',128.21declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
into #11
from aa
group by yewy
order by jine desc
set rowcount 0
select * from #11
drop table #11
drop table aa
/*测试结果:
陈小影 1266.9200*/
to: meilian01(meilian)请告诉我你测试的结果,把你的查询连续执行5次,再看看结果??然后再运行下面的查询?
declare @a int
set @a=1
set rowcount @a
select yewy,sum(jine) jine
from aa
group by yewy
order by jine desc
set rowcount 0 -- 此处加上这个问题,'小李铅笔刀'也测试的,确实有问题?
再说我也没有必要骗你?我还要给经理答复呢??