忘了一点,报表中的 金额(TOTAL) 是按由大到小排的(就是DESC):)
解决方案 »
- oracle游标问题
- oracle子分区索引重建问题
- ORACLE安装完毕还要配置环境变量?
- 关于不用UNION问题.。。急在线等
- 在线等 SQLplus 执行问题
- 用哪个命令来分析SQL语句的执行效率?
- 如何倒出数据库的问题,请大家帮助。
- send one complex porblem on 'sql ' to our friends ,come here plese,baby,baby!!
- 怎样将内存中的大批记录插入到oracle表中效率最高?
- 下载jids jdbc driver 输入的oracle web账户密码错误,但是我的账户密码是刚注册的并能成功登陆oracle官网
- 关于oracle的两个问题
- Hot_Forever(卡尼吉亚),enhydraboy(乱舞的浮尘), black_snail(●龙飞虎○),znbalan()请进来接分
CUID,CUNAME,COUNTRY,sum_t from
(select SELLER,CUID,CUNAME,COUNTRY,sum(TOTAL) sum_t
from SALE a,CUSTOMER b
where a.CUID = b.CUID
and a.orderdate between '*****' and '*****'
group by SELLER,CUID,CUNAME,COUNTRY
order by 5 desc )
---------------------
张三 001 ABC 英国 12677.32
002 CEA 美国 39439.43
赵明 003 QQ2 .... 7367.32
004 CAO .... 394304.43
SELECT CUID,CUNAME,COUNTRY,Sum(TOTAL) FROM CUSTROMER,SALE WHERE CUSTOMER.CUID=SALE.CUID GROUP BY CUID
这条语句比较难解
lag(null,1,SELLER) over (partition by SELLER order by SELLER)这三个SELLER不用指定是哪个表的吗?(不好意思,我很菜:)
你的语句运行有错。原来我也是想这样的。
如果语句是这样就可以正确执行:
SELECT CUID,Sum(TOTAL) FROM CUSTROMER,SALE WHERE
CUSTOMER.CUID=SALE.CUID GROUP BY CUID
ORDER BY Sum(TOTAL) DESC
select lag(null,1,SELLER) over (partition by SELLER order by SELLER) the_s,
CUID,CUNAME,COUNTRY,sum_t from
(select a.SELLER,a.CUID,CUNAME,COUNTRY,sum(TOTAL) sum_t
from SALE a,CUSTOMER b
where a.CUID = b.CUID
and a.orderdate between '*****' and '*****'
group by a.SELLER,a.CUID,CUNAME,COUNTRY,
order by sum(TOTAL) desc )
其实也没有必要,直接这样也行
select a.SELLER,a.CUID,CUNAME,COUNTRY,sum(TOTAL) sum_t
from SALE a,CUSTOMER b
where a.CUID = b.CUID
and a.orderdate between '*****' and '*****'
group by a.SELLER,a.CUID,CUNAME,COUNTRY,
order by sum(TOTAL) desc