如何用sql提取最大值?

我想提取数据表中一个数字字段的最大值,请问怎么取?

表如下:

NUm // 字段

1
3
4
9
3
32
13

通过语句将32取出付给MaxNum,最好别用循环

---------------------------------------------------------------

MAX(NUm)
---------------------------------------------------------------

select top 1 * from tbl order by Num Desc
---------------------------------------------------------------

同上
---------------------------------------------------------------

select top 1 Cast(num As Int) from tbl order by Num Desc

Published At
Categories with Web编程
Tagged with
comments powered by Disqus