fbpx

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 

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…