如何在表中找到最大数量 [英] How to find the maximum number in the table

问题描述

请找到下面的sql server - 总表。



Col 1 Col 2 Col 3 Col 4

1 5 6 8

11 14 18 12





i希望在总表中输出最大数量。

解决方案

使用UNPIVOT：

  SELECT  MAX（vx） FROM  MyTable  AS  a 
 UNPIVOT（vx  FOR 值 IN （Col1，Col2，Col3，Col4））  AS  up 

错误：错过了AS a[ / edit]

Solution1 by OriginalGriff [ ^ ]非常好。作为替代方案，请检查：

  SELECT  MAX（A. MyValue）
  FROM （
  SELECT  Col1  AS  MyValue 
  FROM  TableName 
  UNION   ALL  
  SELECT  Col2  AS  MyValue 
  FROM  TableName 
  UNION   ALL  
  SELECT  Col3  AS  MyValue 
  FROM  TableName 
  UNION   ALL  
  SELECT  Col4  AS  MyValue 
  FROM  TableName 
） AS  A 

Hi,

Please find the below sql server - total table.

Col 1 Col 2 Col 3 Col 4
1 5 6 8
11 14 18 12


i want to out put of maximum number in the total table.

解决方案

Use UNPIVOT:

SELECT MAX(vx) FROM MyTable AS a
UNPIVOT (vx FOR Value IN (Col1, Col2, Col3, Col4)) AS up

[edit]Typo: missed "AS a"[/edit]

Solution1 by OriginalGriff[^] is very good. As an alternative, check this:

SELECT MAX(A.MyValue)
FROM (
    SELECT Col1 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col2 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col3 AS MyValue
    FROM TableName 
    UNION ALL
    SELECT Col4 AS MyValue
    FROM TableName 
) AS A

这篇关于如何在表中找到最大数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！