表(us):
a b c
10 20 2004-05-09 10:20:01
20 30 2004-05-06 10:20:01
60 50 2004-05-08 10:20:01
40 80 2004-05-09 10:20:01
求(统计):
a b c
20 30 2004-05-06
60 50 2004-05-08
50 100 2004-05-09
sql语句:
a b c
10 20 2004-05-09 10:20:01
20 30 2004-05-06 10:20:01
60 50 2004-05-08 10:20:01
40 80 2004-05-09 10:20:01
求(统计):
a b c
20 30 2004-05-06
60 50 2004-05-08
50 100 2004-05-09
sql语句:
sum(b) as b,
convert(varchar(10),c,120) as c
from us
group by convert(varchar(10),c,120)
提示convert未定义