求非0的最小值
程序代码:
create cursor b1 (jnh N(2),m1 n(3),m2 n(3),m3 n(3),min n(3)) insert into b1 values (1,60,0,58,89,58) insert into b1 values (2,0,0,58,89,58) insert into b1 values (3,65,70,0,89,65) insert into b1 values (4,60,0,0,89,60)
在m1、m2、m3中如何求非0的最小值(如字段min所显示)?
谢谢!