从表中获取详细信息 [英] To get details from a table

问题描述

如何编写查询以获取结果

Hi,

how to write a query to get the out put

Emp_id     EMP_name   Manger_id

  1          kiran     Null
  2          stephen    1
  3          Basha      2
  4          surya      3

我想把输出放在

and i want the out put as

Emp_name    Manager Name
kiran         Null
stephen      kiran
 Basha      stephen
 surya       Basha

推荐答案

DECLARE @tmp as Table(ID int,EmpName varchar(10),ManagerID int)
INSERT INTO @tmp  SELECT 1,'Kiran',null
INSERT INTO @tmp  SELECT 2,'Stephen',1
INSERT INTO @tmp  SELECT 3,'Basha',2
INSERT INTO @tmp  SELECT 4,'Surya',3

SELECT
    t1.*,
    t2.EmpName ManagerName
FROM @tmp t1
    LEFT JOIN @tmp t2
ON  t1.ManagerID = t2.ID

开始 ^ ]-它比您开始浏览时要容易.

Start here[^] - it''s easier than it looks once you get going.

使用 ^ ]

这篇关于从表中获取详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！