求一条SQL语句？在线等 ！！！！谢谢

[loye]

我要取一个数字类型字段的最小值，但是要排除重复的。

[oracle100]

我建议你写一个存储过程

[yesterday2000]

select distinct min(col) as col from TB

[yesterday2000]

select distinct min(col) as col from TB

[AntingZ]

select top 1 min(字段1) from 表
group by 字段1
having count(*) =1
order by min(字段1) asc

[loye]

to :yesterday2000(一笑而过)
按照您的意思，可以求出最小的，但是不能排除重复的
我的意思是，求最小，如果有重复的就排除在外。

[loverpyh]

select min(col) as col from TB where col not in(select col from TB group by col having count(*)>0)