SQL查询从表中检索数据 [英] Sql query for retrieving data from a table

问题描述

一个雇员表，其字段为:SlNo，Ename，MgrID.


SlNo EName MgrId

1 A 2
2 B 3
3 C 1



结果应为:

EName MgrName

A B
C A


此结果的Sql查询吗?

An employee table with fields :SlNo,Ename,MgrID.


SlNo EName MgrId

1 A 2
2 B 3
3 C 1



Result should be:

EName MgrName

A B
C A


The Sql query for this Result?

推荐答案

SELECT A.EName as EName , B.EName as MgrName FROM employee A INNER JOIN employee B on A.SlNo = B.MgrId

看看SQL 内部加入 [ ^ ]并尝试编写一个查询.
如果仍然没有解决方案，请在此处发布查询，然后有人会为您提供帮助.

Have a look at the SQL Inner Join[^] and try writing a query.
If you still dont get a solution, post your query here and someone will help you.

SELECT A.EName as EName , B.EName as MgrName FROM employee A INNER JOIN employee B on B.SIno= A.MgrID

这篇关于SQL查询从表中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！