怎么没人回啊?
在Oracle中GROUPING这句话报错!
请高手帮忙!
在Oracle中GROUPING这句话报错!
请高手帮忙!
解决方案 »
- 【求助】oracle 11g Flashback data archive支持带blob字段的表吗??
- 求个查询
- Sequence的问题
- 关于用delphi开发oracle的问题
- 执行alter database switch logfile;无反映?
- 高分求一sql语句.
- CREATE OR REPLACE PROCEDURE p_test(p_string in varchar2,cur_basic out cursor)是错的?
- 强人请进,数据处理。
- pfile与spfile的区别???
- rollback表空间删除了,数据库打不开了,怎么办?
- 与Oracle的连接数量的问题(在线等待)
- Oracle数据库使用什么数据类型的字段存放图片??
(Total), -1, 469771.3400
A , 10952, 491.2000
A , 10835, 851.0000
A , 11011, 960.0000
A , -1, 2302.2000
B , 10926, 514.4000
B , -1, 514.4000
C , 10856, 660.0000
C , -1, 660.0000
D , 10864, 282.0000
D , 10920, 390.0000
D , 11016, 491.5000
D , 10953, 4675.0000
D , -1, 5838.5000
……
theyear number(8):=1998;
begin
select
decode(o.customerid,0,o.customerid,'total') MyCustomerID,
decode(od.orderid,0,od.orderid,-1) MyOrderID,
sum(od.quantity*od.unitprice) Price
from
Orders o, "Order Details" od
where
1=1
and od.orderid=o.orderid
and to_char(o.orderdate,'yyyy')=theyear
group by
decode(o.customerid,0,o.customerid,'total'),
decode(od.orderid,0,od.orderid,-1)
order by
o.customerid,别名.price
end ;
--以上未经测试,
--oracle中: ......
theyear number(8):=1998;
begin
select
decode(o.customerid,0,o.customerid,'total') MyCustomerID,
decode(od.orderid,0,od.orderid,-1) MyOrderID,
sum(od.quantity*od.unitprice) Price
from
Orders o, "Order Details" od
where
1=1
and od.orderid=o.orderid
and to_char(o.orderdate,'yyyy')=to_char(theyear)
group by
decode(o.customerid,0,o.customerid,'total'),
decode(od.orderid,0,od.orderid,-1)
order by
1,3
end ;
老大,怎么没有数据呢/
我把表结构给你:
create table Orders
{
orderid number,
customerid varchar2(11);
employeeid number,
orderdate date,
requiredda date,
shippeddat date,
shipvia number,
freight number,
shipname varchar2(38);
shipaddres varchar2(51);
shipcity varchar2(17);
shipregion varchar2(15);
shippostal number;
shipcountr varchar2(13)
}
create table Order Details
(
orderid number,
productid number,
unitprice number,
quantity number,
discount date
)
帮忙再看看
老大,怎么没有数据呢/
我把表结构给你:
create table Orders
{
orderid number,
customerid varchar2(11);
employeeid number,
orderdate date,
requiredda date,
shippeddat date,
shipvia number,
freight number,
shipname varchar2(38);
shipaddres varchar2(51);
shipcity varchar2(17);
shipregion varchar2(15);
shippostal number;
shipcountr varchar2(13)
}
create table Order Details
(
orderid number,
productid number,
unitprice number,
quantity number,
discount date
)
帮忙再看看
*
from
Orders o, "Order Details" od
where
1=1
and od.orderid=o.orderid
and to_char(o.orderdate,'yyyy')='1998'--你这样测试一下,如果没有数据,那两表关联可能就确实没有数据.
不加的话数据都有/我是想让1998年的数据都显示出来