sql语句sum()求和 不会写了... ( 积分: 50 )

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-27

• #1

select
A.username,A.userid,B.userid,B.djs
from
user A,dj B
where
A.username='" & UserName & "' and B.userid=A.userid


sum(B.djs)求和 咋写呀

 

W

willing66

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-27

• #2

select
A.username,A.userid,B.userid, sum(B.djs)
from
user A,dj B
where
A.username='" & UserName & "' and B.userid=A.userid
group by A.username,A.userid,B.userid

 

S

siking

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-27

• #3

select
A.username,A.userid,B.userid,sum(B.djs)
from
user A,dj B
where
A.username='" & UserName & "' and B.userid=A.userid
group by A.username,A.userid,B.userid

 

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-27

• #4

不对求不出来.
是不是应该写
group by B.djs

 

D

dcx0026

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-27

• #5

你还是用中文教详细描述一下你的目的好了，这样别人才容易帮助你。

 

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #6

还是不行呀.

 

曾

曾经

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #7

select
A.username,A.userid,B.userid,sum(B.djs)
from
user A,dj B
where
A.username='" & UserName & "' and B.userid=A.userid
group by A.username,A.userid,B.userid


就是这个吧

 

F

frankie_24

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #8

应该是对的吧...
你看看你的数据吧,....

 

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #9

sql="select A.username,A.userid,B.userid,B.date,sum(B.djs) as t_djs
from user A,dj B
where A.username='" & UserName & "'
and B.userid=A.userid
and FormatDateTime(B.date,2)=Date()
group by A.username,A.userid,B.userid,B.date"
求和没问提了.我加了一个求当日的 就不行了.
B.date的格式为2007-10-28 21:49:35

 

A

annykuang_643

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-29

• #10

求当日的不能使用FormatDateTime
sql="select A.username,A.userid,B.userid,B.date,sum(B.djs) as t_djs
from user A,dj B
where A.username='" & UserName & "'
and B.userid=A.userid
and Convert(VarChar(10),B.date,120)=Convert(VarChar(10),GetDate(),120)
group by A.username,A.userid,B.userid,B.date"
就OK了啊.前提b.date为日期型

 

X

xiaole_zhm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-30

• #11

sql="select A.username,A.userid,B.userid,B.date,sum(B.djs) as t_djs
from user A,dj B
where A.username='" & UserName & "'
and B.userid=A.userid
and Convert(VarChar(10),B.date,120)=Convert(VarChar(10),GetDate(),120)
group by A.username,A.userid,B.userid,B.date"

 

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-30

• #12

多人接受答案了。