SQL SERVER MAX FORMULA

SQL SERVER MAX FORMULA

--- THEORY

-- SELECT MAX(ColumnName) AS [ALIAS NAME]

-- FROM [DATABASE NAME].[DATABASE OBJECT].[TABLE NAME];

--- EXAMPLE

SELECT MAX(EnglishProductSubcategoryName) AS [DISPLAY MAXIMUM OR HIGHEST TEXT VALUE]
FROM AdventureWorksDW2012.DBO.DimProductSubcategory;