一个查询问题，多谢了！

2012-11-05 10:57:45 271 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

告别乱码！手把手教你用docx4j实现Word转PDF（附完整中文字体配置）本文详细介绍了如何使用纯Java库docx4j实现Word到PDF的精准转换，并重点解决了中文乱码这一核心痛点。文章提供了从环境搭建、核心代码实现到中文字体配置的完整教程，特别针对Linux服务器部署场景，给出了详细的字体安装与映射方案，确保跨平台转换的稳定性和准确性。阅读详情

表1结构
xh dwmc zgbm（主管部门）
1 单位1 A
2 单位2 A
3 单位3 B
4 单位4 B
5 单位5 B
6 单位6 C
表2
dwmc je
单位1 1
单位2 2
单位3 3
单位4 4
单位5 5
单位6 6

想要这种结果,并插入数据库中
mc je
A 3
单位1 1
单位2 2
B 11
单位3 3
单位4 4
单位5 5
c 6
单位6 6

...全文

世界模型和大语言模型结合开发自动驾驶算法摘要：自动驾驶系统开发中，融合世界模型和大语言模型可显著提升效率和安全性。世界模型负责环境感知与预测（如目标检测、轨迹预测），而大语言模型优化代码生成、决策解释等环节。实施路径包括需求分析（1-2周）、模型开发（2-4个月）、模拟测试（1-2个月）、实车测试（2-3个月）和合规优化（1-2个月），总周期6-12个月。关键技术工具包括PyTorch/TensorFlow、CARLA模拟器和ROS系统，核心设计理念强调模块化、安全优先和敏捷迭代。示例代码展示了YOLO目标检测与大语言模型决策建议的集成方案。该方阅读详情

lzuyh

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

-Tracy-McGrady- 2012-11-07

打赏
举报

客气了客气了

坚_持 2012-11-06

打赏
举报

坚_持 2012-11-06

打赏
举报

快溜 2012-11-05

打赏
举报

if object_id('[A]') is not null 
drop table [A]
go 
create table [A]([xh] int,[dwmc] nvarchar(5),[zgbm] varchar(1))
insert [A]
select 1,N'单位1','A' union all
select 2,N'单位2','A' union all
select 3,N'单位3','B' union all
select 4,N'单位4','B' union all
select 5,N'单位5','B' union all
select 6,N'单位6','C'--> 测试数据：[B]
if object_id('[B]') is not null 
drop table [B]
go 
create table [B]([dwmc] nvarchar(5),[je] int)
insert [B]
select N'单位1',1 union all
select N'单位2',2 union all
select N'单位3',3 union all
select N'单位4',4 union all
select N'单位5',5 union all
select N'单位6',6
go

select mc,je from 
 (select a.zgbm as mc,sum(b.je) as je,1 as no,a.zgbm 
     from A a join B b on a.dwmc=b.dwmc group by zgbm
 union all
  select b.dwmc,b.je,2,a.zgbm 
    from A a join B b on a.dwmc=b.dwmc) t
 order by zgbm,no 
 
 /*
 mc    je
----- -----------
A     3
单位1   1
单位2   2
B     12
单位3   3
单位4   4
单位5   5
C     6
单位6   6

快溜 2012-11-05

打赏
举报

select mc,je from (select a.zgbm as mc,sum(b.je) as je,1 as no,a.zgbm from 表1 a join 表2 b where a.dwmc=b.dwmc group by zgbm union all select b.dwmc,b.je,2,a.zgbm from 表1 a join 表2 b where a.dwmc=b.dwmc) order by zgbm,no

开着拖拉机泡妞 2012-11-05

打赏
举报


----------------------------------------------------------------
-- Author  :TravyLee
-- Date    :2012-11-05 11:03:23
-- Version:
--      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) 
--	Jul  9 2008 14:43:34 
--	Copyright (c) 1988-2008 Microsoft Corporation
--	Developer Edition on Windows NT 6.1 <X86> (Build 7600: )
--
----------------------------------------------------------------
--> 测试数据：[A]
if object_id('[A]') is not null drop table [A]
go 
create table [A]([xh] int,[dwmc] varchar(5),[zgbm] varchar(1))
insert [A]
select 1,'单位1','A' union all
select 2,'单位2','A' union all
select 3,'单位3','B' union all
select 4,'单位4','B' union all
select 5,'单位5','B' union all
select 6,'单位6','C'
--> 测试数据：[B]
if object_id('[B]') is not null drop table [B]
go 
create table [B]([dwmc] varchar(5),[je] int)
insert [B]
select '单位1',1 union all
select '单位2',2 union all
select '单位3',3 union all
select '单位4',4 union all
select '单位5',5 union all
select '单位6',6
go
with
t as(
select
	A.dwmc,
	A.zgbm,
	B.je
from
	A 
inner join
	B 
on
	A.dwmc=B.dwmc
)
select 
	 zgbm,
	 SUM(je) as je
from
	t
group by
	zgbm
union all
select
	dwmc,
	je
from
	t
/*
zgbm  je
----- -----------
A     3
B     12
C     6
单位1   1
单位2   2
单位3   3
单位4   4
单位5   5
单位6   6

(9 行受影响)


*/

极品老土豆 2012-11-05

打赏
举报


if(object_id('a') is not null) drop table a
go
create table a
(
xh int,
dwmc varchar(20),
zgbm varchar(1)
)
go
insert into a
select 1,'单位1','A' union all
select 2,'单位2','A' union all
select 3,'单位3','B' union all
select 4,'单位4','B' union all
select 5,'单位5','B' union all
select 6,'单位6','C'
go
if(object_id('b') is  not null) drop table b
go
create table b
(
dwmc varchar(50),
je int
)
go
insert into b
select '单位1',1 union all
select '单位2',2 union all
select '单位3',3 union all
select '单位4',4 union all
select '单位5',5 union all
select '单位6',6 


select a.zgbm as mc,sum(b.je)as je from a inner join b on a.dwmc = b.dwmc group by a.zgbm
union all
select a.dwmc as mc,je from a inner join b on a.dwmc = b.dwmc 

/*
mc                   je
-------------------- -----------
A                    3
B                    12
C                    6
单位1                  1
单位2                  2
单位3                  3
单位4                  4
单位5                  5
单位6                  6

(9 行受影响)

*/

让你望见影子的墙 2012-11-05

打赏
举报

with cte as
(
select dwmc=case when grouping(dwmc)=1 then  zgbm else dwmc end,je=sum(je)
from (select zgbm,a.dwmc,je
      from a join b on a.dwmc=b.dwmc)K
group by zgbm,dwmc
with rollup
)
select * from cte where dwmc is not null

一个查询问题，多谢了！

相关推荐