使用的组合
min()和
abs():
select numfrom mytablewhere abs(num) = (select min(abs(num)) from mytable)
要打破平局,请将num()或max()应用于num以获得消极或积极的一面,例如
要获得平局的负面结果:
select min(num) num from mytablewhere abs(num) = (select min(abs(num)) from mytable)
要获得平局,请执行以下操作:
select max(num) numfrom mytablewhere abs(num) = (select min(abs(num)) from mytable)



