SQL sum函数用于统计某一列的和;
1 SQL Server 中操作
原表;
统计paynum列的和;
sql对字段可以使用别名,语法是: as xxx;使用别名后如下;
全部运行一下;
select * from mempays
select SUM(paynum) from mempays
select SUM(paynum) as paynums from mempays
2 Sqlite 中操作
S:\sqlite>sqlite3 test1
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables;
Error: unknown command or invalid arguments: "tables;". Enter ".help" for help
sqlite> .tables
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main S:\sqlite\test1
sqlite> create table Students(
...> Id int primary key not null,
...> TeacherID int,
...> Name varchar(255),
...> Age int);
sqlite> insert into Students values (1,4,'小明',10);
sqlite> insert into Students values (2,5,'小白',12);
sqlite> insert into Students values (3,4,'小红',11);
sqlite> insert into Students values (4,5,'小白1',14);
sqlite> insert into Students values (5,4,'小红1',15);
sqlite> insert into Students values (6,6,'小明2',10);
sqlite> insert into Students values (7,6,'小白2',12);
sqlite> insert into Students values (8,6,'小红2',11);
sqlite> insert into Students values (9,5,'小白2',14);
sqlite> insert into Students values (10,4,'小红2',15);
sqlite> select * from Students
...> ;
1|4|小明|10
2|5|小白|12
3|4|小红|11
4|5|小白1|14
5|4|小红1|15
6|6|小明2|10
7|6|小白2|12
8|6|小红2|11
9|5|小白2|14
10|4|小红2|15
sqlite> select sum(Age) as ages from Students;
124
sqlite>
3 Access中操作
使用网上下的一个单独Access工具;
新建一个表;Access似乎没有 varchar 类型,只有Text类型,默认长度255; ID默认是AutoNumber类型;
这工具录入数据也可以的;然后操作一下 sql SUM() 函数;