4
Reply

How to write the query for my output

narasiman rao

narasiman rao

Nov 26 2012 3:34 AM
2.9k

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

Answers (4)