
复制declare @sale table( FName nvarchar(50),将数据库接转
FDistrict nvarchar(50), FAmount decimal(28,10) ); insert into @sale values (张三,北京,20000), (张三,上海,50000), (张三,深圳,40000), (张三,广州,30000), (李四,北京,30000), (李四,上海,50000), (李四,深圳,40000), (李四,广州,10000); 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.