Answers for "sql get int max value"

mssql int max value

--			SIGNED										  UNSIGNED
--			Min               		Max                   Min Max
TINYINT     -128                    127                   0   255
SMALLINT    -32767                  32767                 0   65535
MEDIUMINT   -8388608                388608                0   16777215
INT         -2147483648             2147483647            0   4294967295
INTEGER     -2147483648             2147483647            0   4294967295
BIGINT      -9223372036854775808    9223372036854775808   0   18446744073709551615

find max number in sql

● SELECT first-name, MAX(salary)
FROM department d LEFT OUTER JOIN employee e ON (d.department_id = e.department_id)
GROUP BY department_id;