sql语句的困惑,希望大家帮忙(80)

N

newmaid

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-08

• #1

oracle 表a字段: 名称,日期,次数sql语句1. select a.名称,sum(a.次数) as a1 from a where 日期='1900-01-01' sql语句2. select a.名称,sum(a.次数) as a2 from a where 日期<>'1900-01-01'我想显示结果如下,(用一句sql写出)名称,次数,a1,a2...............请问应该如何写sql语句,新手,请否吝指教.万分感谢!

 

Z

znxia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-08

• #2

select a.名称, sum(次数) 次数, Sum(Case when 日期='1900-01-01' then 次数 else 0 end) a1, Sum(Case when 日期<>'1900-01-01' then 次数 else 0 end) a2from agroup by a.名称

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-09

• #3

楼上可行

 

N

newmaid

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-09

• #4

接受答案了.