+ 1

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

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

12th Oct 2017, 10:35 AM
Gokulakrishnan
Gokulakrishnan - avatar
1 Odpowiedź
0
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 ?
13th Oct 2017, 8:24 PM
sneeze
sneeze - avatar