从缺失值中选择最小值 [英] Select min value from missing values

问题描述

大家好，

我正在从表格中选择缺失的数字.
表名称= DespTruck
字段= CR_No

这是我的查询，用于从表DespTruck中选择缺少的值.

Hi all,

I am selecting the missing numbers from a table.
Table name = DespTruck
Field = CR_No

Here is my query for selecting missing values from table DespTruck.

;WITH Missing (missnum, maxid)
AS
( 
SELECT 1 AS missnum, (select max(CR_No) from DespTruck)
UNION ALL SELECT missnum + 1, maxid FROM Missing 
WHERE missnum < maxid
)
SELECT missnum FROM Missing 
LEFT OUTER JOIN DespTruck e on e.CR_No = Missing.missnum
WHERE e.CR_No is NULL OPTION (MAXRECURSION 0);

=================
运行此查询后，我的结果是:

=================
After running this query my result is like :

missing num
463
825
985
1011
1853
etc...

=========

现在，我想从此结果中选择最小值(即463).

任何帮助将不胜感激.

在Advance中致谢

=========

Now I would like to select minimum value ( which is 463 ) from this result.

Any help will be highly appreciated.

Thanks in Advance

推荐答案

非常简单

SELECT MIN(column) FROM table

这篇关于从缺失值中选择最小值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！