我想提取数据表中一个数字字段的最大值,请问怎么取?
表如下:
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