如何写sql的分子语句

Question

如果 TRUNC(MONTHS_BETWEEN(SYSDATE, A.YGRSSJ)/ 12)*50>=200,z则查出的值就为200
否则，值为 TRUNC(MONTHS_BETWEEN(SYSDATE, A.YGRSSJ)/ 12)*50如何写查询语句呢？

Answer 1

case when TRUNC(MONTHS_BETWEEN(SYSDATE,   A.YGRSSJ)/   12)*50> =200
     then 200
     else TRUNC(MONTHS_BETWEEN(SYSDATE,   A.YGRSSJ)/   12)*50
end

Answer 2

try it ..
select decode(sign(TRUNC(MONTHS_BETWEEN(SYSDATE,A.YGRSSJ)/12)*50-200),-1,TRUNC(MONTHS_BETWEEN(SYSDATE,A.YGRSSJ)/12)*50,200)
  from dual;

Answer 3

用case when 吧,这样比较直观,易读