Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Get Minimum from multiple columns sql

SELECT ID, Col1, Col2, Col3, 
    (SELECT MIN(Col) FROM (VALUES (Col1), (Col2), (Col3)) AS X(Col)) AS TheMin
FROM Table
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #Get #Minimum #multiple #columns #sql
ADD COMMENT
Topic
Name
5+1 =