narasiman rao

narasiman rao

  • NA
  • 519
  • 767k

How to write the query for my output

Nov 26 2012 3:34 AM

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)