SQL SERVER MIN FORMULA

SQL SERVER MIN FORMULA

--- THEORY

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

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

--- EXAMPLE

SELECT MIN(EnglishProductSubcategoryName) AS [DISPLAY MINIMUM OR LOWEST TEXT VALUE]
FROM AdventureWorksDW2012.DBO.DimProductSubcategory;