• SQL Aggregate Functions – SUM, COUNT, MAX, MIN, AVG
• SQL COUNT Function – How to Count Rows In a Table with Examples
• SQL ISNULL and COALESCE Functions – What Are The Differences And Usage
• SQL OFFSET Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE
• SQL Ranking Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
• SQL REPLACE Function – Replace Text String
• SQL String Functions – Overview of Text Functions in T-SQL
• SQL SUBSTRING Function – Get Part of String With Example