需要查询以使用select语句添加自定义行. [英] Need Query to add custom row with select statement.

问题描述

我有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屋！