Revisions to SQL MAX of multiple columns?

deleted 3 characters in body

Source Link

edited May 27, 2019 at 10:29

2.6k
4
29
36

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaxName) 
   FROM ( VALUES 
            (MAX(iSortCodeField1)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaxName) 
   FROM ( VALUES 
            (MAX(iSortCode)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaxName) 
   FROM ( VALUES 
            (MAX(Field1)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

edited body

Source Link

edited Mar 3, 2017 at 8:59

jjaskulowski

2.6k
4
29
36

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaximumMyMaxName) 
   FROM ( VALUES 
            (MAX(iSortCode)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaximum) 
   FROM ( VALUES 
            (MAX(iSortCode)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaxName) 
   FROM ( VALUES 
            (MAX(iSortCode)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

Source Link

answered Apr 1, 2015 at 8:12

jjaskulowski

2.6k
4
29
36

For T-SQL (MSSQL 2008+)

SELECT
  (SELECT
     MAX(MyMaximum) 
   FROM ( VALUES 
            (MAX(iSortCode)), 
            (MAX(Field2)) 
        ) MyAlias(MyMaxName)
  ) 
FROM MyTable1

Collectives™ on Stack Overflow

Return to Answer