PARTITION BY, RANK() and DENSE_RANK()

Real-World example of using SQL Server to assist in making a puzzle book!!

IF EXISTS, DROP TABLE, SELECT INTO, INSERT INTO, SYSOBJECTS, XTYPE

SQL SERVER CASE SENSITIVITY TRICK

SQL SERVER CASE SENSITIVITY TUTORIAL

SQL SERVER CASE SENSITIVITY LESSON

HOW TO CREATE NEW SQL SERVER TABLE SCHEMA

SQL SERVER CREATE NEW SCHEMA TUTORIAL

SQL SERVER CREATE NEW SCHEMA LESSON

SQL SERVER: CHANGE TABLE SCHEMA

SQL SERVER CREATE NEW SCHEMA

SQL SERVER CASE SENSITIVITY

SQL MAX, MIN , AVG FUNCTIONS along with GROUP BY and PARTITION BY

REALLY FAST SQL CONCAT() FUNCTION TUTORIAL

SQL SUM, AVG FUNCTIONS along with GROUP BY and PARTITION BY

SQL MAX, MIN and AVG FUNCTION and GROUP BY and PARTITION BY

QUICK SQL CONCAT() FUNCTION LESSON

SQL SUM FUNCTION along with GROUP BY and PARTITION BY

SQL SUM and AVG FUNCTION and GROUP BY and PARTITION BY

QUICK SQL CONCAT() FUNCTION TUTORIAL

SQL MAX, MIN & AVG FUNCTION WITH GROUP BY

SQL MAX() FUNCTION, MIN() FUNCTION, AVG() FUNCTION, SUM() FUNCTION GROUP BY

QUICK SQL CONCAT() FUNCTION EXAMPLE

SQL SUM FUNCTION and GROUP BY and PARTITION BY

SQL SUM & AVG FUNCTION WITH GROUP BY