获取sql server中每行的MAX和MIN值 [英] Get MAX and MIN values of each rows in sql server

问题描述

我有一组带有值的行

我想要具有单独最大值和最小值的以下输出

I want the following OutPut with individual Max and min values

对不起可怜的prntsceen.我不知道如何在 stackoverflow 中绘制表格.

Sorry for the poor prntsceen. i dont know how to draw tables in stackoverflow.

推荐答案

select value1, value2, value3, value4,
       [min]=(select min(value) from (
              select value1 union all
              select value2 union all
              select value3 union all
              select value4) X(value)),
       [max]=(select max(value) from (
              select value1 union all
              select value2 union all
              select value3 union all
              select value4) Y(value))
  from tbl;

要将 NULL 识别为 min 值，请改用以下代码

To recognize NULLs as min values, use the below instead

select value1, value2, value3, value4,
       [min]=(select TOP(1) value from (
                 select value1 union all
                 select value2 union all
                 select value3 union all
                 select value4) X(value)
              ORDER BY value ASC),
       [max]=(select TOP(1) value from (
                 select value1 union all
                 select value2 union all
                 select value3 union all
                 select value4) X(value)
              ORDER BY value DESC)
  from tbl;

这篇关于获取sql server中每行的MAX和MIN值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！