请教SYBASE中SQL语句问题

一分钱太少

各个大虾：
请问如何在SYBASE中实现类似于
SELECT P1.*, (P1.Q1 + P1.Q2 + P1.Q3 + P1.Q4) AS YearTotal
FROM (SELECT Year,
             SUM(CASE P.Quarter WHEN 1 THEN P.Amount ELSE 0 END) AS Q1,
             SUM(CASE P.Quarter WHEN 2 THEN P.Amount ELSE 0 END) AS Q2,
             SUM(CASE P.Quarter WHEN 3 THEN P.Amount ELSE 0 END) AS Q3,
             SUM(CASE P.Quarter WHEN 4 THEN P.Amount ELSE 0 END) AS Q4
     FROM Pivot AS P
     GROUP BY P.Year) AS P1
功能的SQL语句？

一分钱太少

各位请帮忙看一下吧!多谢啦!

clytcn

借个地方
error????
select au_fname, au_lname, pub_name
from authors left join publishers
on authors.city = publishers.city

qjhadm

原帖由 "clytcn" 发表：
借个地方
error????
select au_fname, au_lname, pub_name
from authors left join publishers
on authors.city = publishers.city

不知道你select 说取得字段来自authors 还是 publishers
试着加上表名试试

一分钱太少

难道就没有一个人知道吗？郁闷!

sybase-bud

select P.Year,
SUM(abs(p.Amount)*(1-abs(sign(p.Quarter-1)))) AS Q1
SUM(abs(p.Amount)*(1-abs(sign(p.Quarter-2)))) AS Q2
SUM(abs(p.Amount)*(1-abs(sign(p.Quarter-3)))) AS Q3
SUM(abs(p.Amount)*(1-abs(sign(p.Quarter-4)))) AS Q4
FROM pivot as p
GROUP BY p.Year
... ...


你是这个意思吧，我发觉sybase好像没有列聚集函数，所以用了符号算法。

第一次来本论坛，非专业人员，请多关照