需要查询以使用select语句添加自定义行. [英] Need Query to add custom row with select statement.
本文介绍了需要查询以使用select语句添加自定义行.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有2张这样的桌子.
I have 2 tables like this.
推荐答案
尝试此操作
Try this
DECLARE @ENameTable AS Table (ECode BIGINT, EName NVARCHAR(50))
DECLARE @ManagerTable AS Table (ECode BIGINT, ManagerName NVARCHAR(50))
INSERT INTO @ENameTable
SELECT 1,'Ram' UNION
SELECT 2,'Shayam' UNION
SELECT 3,'Hari' UNION
SELECT 4,'Joseph' UNION
SELECT 5,'Abdul'
INSERT INTO @ManagerTable
SELECT 1,'Peter' UNION
SELECT 2,'Mac' UNION
SELECT 3,'Mac' UNION
SELECT 4,'Peter' UNION
SELECT 5,'Peter'
SELECT First_Col,Sec_col FROM
(
SELECT 1 rwid,ManagerName First_Col, ManagerName + CAST(COUNT(ManagerName) AS NVARCHAR(10)) Sec_col FROM @ManagerTable GROUP BY ManagerName
UNION ALL
SELECT 2 rwid ,M.ManagerName First_Col,E.EName Sec_col FROM @ENameTable E Inner Join @ManagerTable M ON E.ECode=M.ECode
) AS TBLE
ORDER BY First_Col,rwid
这篇关于需要查询以使用select语句添加自定义行.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文