一个简单问题快来拿分

[lianhuang]

一个sql语句 想从数据库中取某一字段的累加值例如把字段月为12的工资值累加起来.如何写!请教了
sql_gz="select ....... from sy_gzb where to_char(DT_RIQI,'yy') = '"&nian& "
set rs_gz=conn.execute (sql_gz)
response.write 工资累加值

[「已注销」]

select sum(字段) s from .. where..

[平台想钱想疯了]

select sum(字段) s from .. where..


=====================================


来晚了。UP

[zzy0000]

同上

[香椿炒鸡蛋]

select sum(字段) as strVaue from sy_gzb where month(日期字段)=12 ^_^