# What does SELECT MIN(+ - Column) do?

Eric S 07/11/2018. 1 answers, 212 views

I ran into a query today that did something I haven't seen before. It did something like this:

SELECT
MIN(+ - schema_id) AS [WhatInTheWorld?],
MIN(schema_id) AS MinimumID,
MAX(+ - schema_id) AS [Uhhh],
MAX(schema_id) AS MaxID
FROM sys.objects

Which gives the following results:

WhatInTheWorld? MinimumID    Uhhh       MaxID
-4              1            -1         4

What exactly are the "+" and "-" doing?

ypercubeᵀᴹ 07/19/2018.

MIN(+ - schema_id) is parsed as MIN( + (- schema_id) ) which is the same as MIN(- schema_id), so it's (mathematicaly)* the same as -MAX(schema_id). Likewise for the MAX.

*: There are some edge cases when the MIN/MAX(-x) might raise an error while the - MAX/MIN(x) will not (because the negation is applied in all values of the column vs only to the MAX/MIN value).