Test your database query skill

[ramanathan]

Hi,

 Below is the table showing some records, you need to create a query which has the output showing the employee name and his related lead name

Table data's

emp_id	emp_name	lead_id
1	Palaniappan	1
2	moorthy	1
3	senthil	1
4	manoj	2
5	deepa	3

the result will be

emp_name	lead_name
Palaniappan	Palaniappan
moorthy	Palaniappan
senthil	Palaniappan
manoj	moorthy
deepa	senthil

Note: it is single table not seperate table

Ramanathan.

[Muthuganesh]

Hi ramanathan,
                       There may be more than one solution(query) to this problem.I am sure this will be one of the solutions.
                 
select t1.emp_name,t2.emp_nam as lead_name from employee t1,employee t2 where t1.lead_id=t2.emp_id;

TableName:
employee=tablename

Fields
emp_name
emp_id
lead_id

Description:

Its a simple join in same table

t2 and t1 is the alis name of that table,usually we use 2 table in different name here you refer same table.If you did'nt give that where condition it show all combination.

I request you to give me feedback for this solution

M.Muthuganesh
Navagate