How to select & vary a particular colomn alone by any arithmetic operation and to display all colomns?

Question

Note : the learning module has same lesson but it selects all individually instead of using *

Answer 1

sql is fun when it comes to vary with columns

used Northwind to test my queries

Select * from Employees
//all columns, order same as design

Select FirstName, LastName from Employees
//columns FirstName, LastName in that order

Select LastName, FirstName from Employees
//the other way arround

Select FirstName + ' ' + LastName from Employees
//Concatenated field no header

Select FirstName + ' ' + LastName as Name from Employees
//Concatenated field with header

What else do you want to do ?