SELECT如何实现上行数据和本行数据相加或相减 select a.ID,a.C1,sum(b.C1) as C2 from 表 a,表 b where a.ID>=b.ID group by a.ID,a.C1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE TABLE TB([ID] INT, [C1] INT)INSERT TB SELECT 1, 10 UNION ALL SELECT 2, 1 UNION ALL SELECT 3, 100 UNION ALL SELECT 4, 200SELECT *,(SELECT SUM(C1) FROM TB WHERE ID<=T.ID)FROM TB AS TDROP TABLE TB/*ID C1 ----------- ----------- -----------1 10 102 1 113 100 1114 200 311*/ SELECT *,(SELECT SUM(C1) FROM TB WHERE ID-1<T.ID) AS C2FROM TB AS T mssql数据库的数据量在多少时,性能差别较明显 怎样将一个存储过程执行后的结果集存储在指定的视图里???????????????? 后台用SQL,前台客户端用什么编好啊?VC合适吗? myeclipse连接sql server2005 请问大家如何给表删除一个列阿 请教大家了! SQL表中长度为20位的数字该用什么数据类型啊?? access转换成sql的问题 这条sql语句怎么写(vb版里没解决,到这试试) sql关于存储过程的超难问题 比较麻烦的sql请高手帮忙 求细表的执行情况写入主表,请教!
INSERT TB
SELECT 1, 10 UNION ALL
SELECT 2, 1 UNION ALL
SELECT 3, 100 UNION ALL
SELECT 4, 200SELECT *,(SELECT SUM(C1) FROM TB WHERE ID<=T.ID)
FROM TB AS TDROP TABLE TB
/*
ID C1
----------- ----------- -----------
1 10 10
2 1 11
3 100 111
4 200 311
*/
(SELECT SUM(C1) FROM TB WHERE ID-1<T.ID) AS C2
FROM TB AS T