Select from following answers:- Ram, Shyam, Jadhu, Madhu

- Madhu,Jadhu,Shyam,Ram
- NULL
- Error
- All Above
Since all are strings, so the result will be the concatenation of all those rows i.e. Ram, Shyam, Jadhu, Madhu.Now the CONCAT function ignores the NULL and inside the IIF we are checking if the VALUE is NULL which is not true. Henceforth, the result will be Ram, Shyam, Jadhu, Madhu
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator