Saturday, July 24, 2010

Employee table

FirstName LastName 
Raju Das
RaviKumar
PrashantNULL
SashiNULL

Look at this SQL query --
 

    Select FirstName+ '  '+ LastName from Employee

Which correct output from the following –


1)                               2)
FirstName 
 Raju Das
 Ravi Kumar
Prashant NULL
Sashi NULL
FirstName 
 Raju Das
 Ravi Kumar
Prashant
Sashi
                                                                                                                                              
      







3)                                4)
FirstName 
 Raju Das
 Ravi Kumar
NULL
NULL
FirstName 
 Raju Das
 Ravi Kumar


                                                                                                                                              
      









Correct answer is 3


No comments:

Post a Comment


All Rights Reserved @ Raju Das