select name,sum(money) from a group by name 以前有很多这样的例子啊
如果我要输出 1 a 100 2 b 200 3 c 400 4 d 500 就是过滤掉一些相同名称的信息,怎么写呀?
select name,min(money) from A group by name
select min(id),name,sum(money) from A group by name
哪如果:我的是一个字符串怎么取呀? id name num 1 1,2,3,4,5, 100 输出: id name num 1 1,2,3,4,5 100
我这样写怎么不行呀? select id ,substring(name,0,name.lenght-1) as name,num from A where id=1
select id ,substring(name,0,len(name)-1) as name,num from A where id=1
select id ,substring(name,0,len(name)-1) as name,num from A where id=1
喔谢谢楼上 哪如果我从数据库里查找出一些数据啦,可能为多条记录 我想把它再插入另一表里,哪我怎么写呀?我是在一个存储过程里写的。 例如: select id ,name,num form A where id in (1,2,3,4,5) 这样是返回一个表吧,就是几条记录吧,记录集。 我怎么把它返回的这几条记录在下一条sql语句里插入到另一个表里呢?用 insert into 怎么弄呀?? 谢谢
create table tablename ( id int, name varchar(5), money money) select * from tablename insert into tablename select 1,'a',100 union select 2,'a',110 union select 3,'b',200 union select 4,'b',300 union select 5,'c',400 union select 6,'d',500delete tablenameselect name,sum(money)from tablename group by nameselect name,min(money) from tablename group by nameselect id,substring(name,0,len(name)-1)as name,money from tablename where id=1
insert into tablename(col1,col2,...) values(col1value,col2value,....)
insert tablename1 select * from tablename2
有两种写法 1.select id ,name,num into B form A where id in (1,2,3,4,5) 2.select * into b from a where where 1=2 --创建表结构 insert B(id, name, num) --插入数据 select id ,name,num form A where id in (1,2,3,4,5)
group by name
以前有很多这样的例子啊
1 a 100
2 b 200
3 c 400
4 d 500
就是过滤掉一些相同名称的信息,怎么写呀?
id name num
1 1,2,3,4,5, 100
输出:
id name num
1 1,2,3,4,5 100
select id ,substring(name,0,name.lenght-1) as name,num from A where id=1
哪如果我从数据库里查找出一些数据啦,可能为多条记录
我想把它再插入另一表里,哪我怎么写呀?我是在一个存储过程里写的。
例如:
select id ,name,num form A where id in (1,2,3,4,5)
这样是返回一个表吧,就是几条记录吧,记录集。
我怎么把它返回的这几条记录在下一条sql语句里插入到另一个表里呢?用
insert into 怎么弄呀??
谢谢
(
id int,
name varchar(5),
money money)
select * from tablename
insert into tablename select 1,'a',100 union
select 2,'a',110 union
select 3,'b',200 union
select 4,'b',300 union
select 5,'c',400 union
select 6,'d',500delete tablenameselect name,sum(money)from tablename group by nameselect name,min(money) from tablename group by nameselect id,substring(name,0,len(name)-1)as name,money from tablename where id=1
values(col1value,col2value,....)
1.select id ,name,num into B form A where id in (1,2,3,4,5)
2.select * into b from a where where 1=2 --创建表结构
insert B(id, name, num) --插入数据
select id ,name,num form A where id in (1,2,3,4,5)