按照company_no和warehouse_no将记录分组,并且将cargo_num和cargo_volume求和(都是一个表中的字段),最后将求和后的结果添加到另一个表中。select sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no;这样行吗?
怎样将所得的结果添加到另一个表中那?
请指教,谢谢!!
怎样将所得的结果添加到另一个表中那?
请指教,谢谢!!
select company_no,warehouse_no,sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no
into new_table
from table1
group by company_no,warehouse_no
select company_no,warehouse_no,check_date, sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no但在sql语句里,必须用字符串,而插入的类型必须是datetime型的,这个问题该怎么解决哪?
select convert(VarhChar(10),GetDate(),120),gcompany_no,warehouse_no,check_date, sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no
select company_no,warehouse_no,convert(VarhChar(10),check_date,120), sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no,check_date
select company_no,warehouse_no,convert(VarhChar(10),check_date,120), sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no,check_date其中 check_date 不是列名,而是变量的名字,我想直接将变量的值付给表中对应的字段,谢谢
select ...
select company_no,warehouse_no,convert(VarhChar(10),check_date,120), sum(cargo_num),sum(cargo_volume) from table1 group by company_no,warehouse_no;其中check_date是变量名,需要将该变量的值插入到数据库中,如何实现??
set check_date = 具體值
insert into tableB(field1,field2,.....)
select company_no,warehouse_no,convert(varchaer(10),check_date,120),sum(cargo_num)
,sum(cargo_volume) from table1 group by company_no,warehourse_no
'warehouse_no, flag_warehouse_io,cargo_name , sum(cargo_num) as ' +
'cargo_num,sum(cargo_weight) as cargo_weight,sum(cargo_volume) as ' +'cargo_volume from db_warehouse_io '+
'where date_warehouse_io <= ld_date_check_end and date_warehouse_io >= ld_date_check_begin '+
'group by company_no, warehouse_no, flag_warehouse_io, cargo_name';
sql.Add(str_sql);
错误提示:
[Error] Unit_time_sel.pas(56): Incompatible types: 'String' and 'TDateTime'
set @check_date='1999-02-03'//变量赋值
cast(@check_date as datetime)//字符转换日期insert into tableB(field1,field2,.....)
select company_no,warehouse_no,cast(@check_date as datetime),sum(cargo_num)
,sum(cargo_volume) from table1 group by company_no,warehourse_no