sql中如何合并两个特定的字段?答:1、创建模拟的数据表 create table GoodsCate(Mid int not null,Code varchar(10) not null,Name varchar(20) not null,)2、添加模拟数据 insert into GoodsCate(Mid,Code,Name) values(1,'6801','电子仪器')insert into GoodsCate(Mid,Code,Name) values(2,'6802','激光仪器')insert into G...
求问SQL 怎么把多个字段名整合成1个答:--1.建原始表 CREATE TABLE TEST_DATE (NAME VARCHAR2(100),YEAR_MONTHS VARCHAR2(100),day1 NUMBER,day2 NUMBER,day3 NUMBER,day4 NUMBER,day5 NUMBER,day6 NUMBER,day7 NUMBER,day8 NUMBER,day9 NUMBER,day10 NUMBER,day11 NUMBER,day12 NUMBER,day13 ...