请问这个错在那里

[qq68435700]

select orderid,sum(unitprice*quantity) from
(select orderid,sum(unitprice*quantity)
from orderdetails
group by orderid) a
where orderid='10246'
错误提球为：没有为第 2 列（属于 'a'）指定列。

意思是先查询出
select orderid,sum(unitprice*quantity)
from orderdetails
group by orderid
然后在通过子查询想查出orderid='10246'的orderid,sum(unitprice*quantity)

[tim_spac]

select orderid,amount 
from (
    select orderid,amount=sum(unitprice*quantity) 
    from orderdetails 
    group by orderid) a
where orderid='10246'

[ORARichard]

select orderid,sum(unitprice*quantity) amount
from orderdetails 
where orderid='10246'
group by orderid

[JL99000]

select a.orderid,a.ZH from
(select orderid,sum(unitprice*quantity) as ZH
from orderdetails
group by orderid) a
where a.orderid='10246'

接分了

[loworth]

[CODE=SQL]
/*改法1*/
select orderid,sum(unitprice*quantity) from
(select orderid,unitprice,quantity
from orderdetails
) a
where orderid='10246'
group by orderid
/*改法2*/
select orderid,acount from
(select orderid,SUM(unitprice*quantity) AS acount
from orderdetails
) a
where orderid='10246'
group by orderid
/*改法3*/
select orderid,sum(unitprice*quantity)
from orderdetails
where orderid='10246'
group by orderid
[/CODE]

[loworth]

改法2把group by 写到子查询里

[wyb0026]

不用费二遍事直接 不行吗？而且效率非常差

select   orderid,sum(unitprice*quantity)   from 
from    orderdetails 
where   orderid='10246' 

你实在坚持应该这样写

select   orderid,sum(amunt)   from 
(select   orderid,sum(unitprice*quantity) amunt 
from   orderdetails 
group   by   orderid) as  a 
where   orderid='10246' 

[中国风]

select orderid,合计 from
(select orderid,sum(unitprice*quantity) as 合计 --少了一个别名，内联视图必须有列名
from orderdetails
group by orderid) a
where orderid='10246'