To merge two columns value as one, we can concatenate it as one and use alias for that value. This is the simplest way to do it.
SELECT FirstName + ' ' + LastName as FullName FROM PersonalDetails
Here the combination of FirstName and LastName is separated by a blank space and given as FullName.
Views: 34084 | Post Order: 56