SQL Server Basic SELECT Examples

-- Basic SELECT Statement

SELECT *
FROM employees 

-- Choosing specific columns 

SELECT lastName , firstName , Address
FROM employees 

-- Naming / Coding Conventions 

SeLEct			LAstNAme,        firstNAME

			FROM
	emplOYEES

select lastname , firstname
from employees

/*
comments
*/

-- Column Calculations 

SELECT *
FROM products 

SELECT productID , productName , unitPrice , UnitPrice * 4 / (434* 34 * 4.23)
FROM products 

SELECT productID , productName , productName + 5
FROM products 

SELECT employeeID , lastName , firstName , hireDate , hireDate + 1
FROM employees 

SELECT employeeID , lastName , firstName , hireDate , hireDate + 365
FROM employees 

SELECT employeeID , lastName , firstName ,hireDate , hireDate * 2
FROM employees 

-- Concatenations 

SELECT lastName , FirstName
FROM employees 

SELECT lastName + FirstName
FROM employees 

SELECT lastName + ' ' + FirstName
FROM employees 

SELECT  'The last name is : ' + lastName +
		' And the firstName is : ' + FirstName
FROM employees 

-- Aliases 

SELECT lastName AS 'LN' , lastName + ' ' + firstName AS 'Full_Name'
FROM employees 

SELECT lastName  LN , lastName + ' ' + firstName  FullName
FROM employees 

-- Distinct 

SELECT productName , categoryID
FROM products 

SELECT DISTINCT categoryID
FROM products 

SELECT DISTINCT city , country
FROM customers