You want to present the last name followed by the first name from a table named Customers in a database named Sales. Which query best meets that goal?

You want to present the last name followed by the first name from a table named Customers in a database named Sales. Which query best meets that goal?

You want to present the last name followed by the first name from a table named Customers in a database named Sales. Which query best meets that goal?


Answer – USE Sales
       SELECT LName + ‘,’ +Fname FROM Customers

(SQL Server uses the plus (+) sign as the concatenation operator.)