select min( 价格) and count(价格)from表 where count(价格)=1select * from table order by id ASC,价格 DESC;select top 1 * from table1 t1 where (select count(*) from table1 where 价格=t1.价格)=1order by 价格 descSELECT id, 价格FROM tabWHERE 价格 = (SELECT MIN(价格) from tab)select min(价格) from 表如果有可能重合 但是只像一条就可以select top 1 min(价格) from 表select hotel_seqfrom 某个表where 时间条件group by hotel_seqhaving count(hotel_seq)=1