CUBE and ROLLUP in SQL Server

How to find Department wise Highest Salary in SQL Server

How to Calculate AGE in SQL Server

Find Youtube ID from Youtube URL using SUBSTRING and CHARINDEX in SQL Server

Find Department wise Total Salary in SQL Server

SUBSTRING, CHARINDEX and PATINDEX in SQL Server

Useful System Stored Procedures sp_help, sp_helptext and sp_depends in SQL Server

LEAD and LAG analytic functions in SQL Server

ROW_NUMBER, RANK and DENSE_RANK in SQL Server

Find nth Highest Salary and nth Lowest Salary of an Employee in SQL Server