Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

MS-SQL Aggregate Functions

SQL Functions: return a single value
• AVG() - Returns the average value
• COUNT() - Returns the number of rows
• MAX() - Returns the largest value
• MIN() - Returns the smallest value
• SUM() - Returns the sum
Select avg(column_name) from table_name
Select count(*) from table_name
Select count(distinct customerid) as numberofcustomer from orders
Select first(column_name) from table_name
Select max(column_name) from table_name
Select max(price) as highestprice from products
Select min(column_name) from table_name
Select sum(column_name) from table_name