How to write the query for my output

Question

EMP Table AS Follows;

EMPID EMPNAME MGRNo MGRNAME

1 Raj Null RAvi

2 Ram 1 Sam

3 Hari 2 Yogi

from the above EMP Table i wan the output as follows;

I want the output

EMPID EMPNAME MGRNAME

1 Raj RAvi

2 Ram Sam

3 Hari Yogi

For that how to write the query in sql server.please help me. uisng sqlserver

Satyapriya Nayak · Answer

If your problem is solved please click the checkbox( This is correct answer ) Thanks

venkata kumar · Answer

hi SELECT EMPIDEMPNAMEMGRNAME FROM EMP Thanks & Regrads Kumar

Vishnujeet Kumar · Answer

select EMPIDEMPNAMEMGRNAME from EMP basic sql you can learn below link.. http://www.w3schools.com/sql/default.asp

Pradip Pandey · Answer

Select EMPID EMPNAME MGRNAME From EMP GO Hope it will help.