sql 横向求和问题答:假如你的数据列名为:a,b,c,d,e,f,g 那么你横向汇总的SQL语句是:select a,b,c,d,e,f,g,a+b+c+d+e+f+g from 表名 那么你纵向汇总的SQL语句是:select sum(a),sum(b),sum(c),sum(d),sum(e),sum(f),sum(g) from 表名 求所有数据总和的SQL语句是:select sum(a)+sum(b)...
SQL语句查询,每隔三天输出一个结果,一个时间段内,比如说三十天的数据...答:/* for M$SQL */declare @firstdate datetime-- find the first dateselect @firstdate = dateadd(day, datediff(day, 0,min(dtfield)), 0) from table_or_resultselect dtgroup = datediff(day, @firstdate, dtfield) / 30, sum(sum_field) as sum_fieldfrom table_or_resultgroup b...