sqlif

xiaoxiao2021-02-28  95

格式:IF(Condition,A,B)

意义:当Condition为TRUE时,返回A;当Condition为FALSE时,返回B。

例子

   select A.student_id,sw,ty from      (select student_id,num as sw from score left join course on score.course_id = course.cid where course.cname =  '生物' ) as A             left join    (select student_id,num  as ty from score left join course on score.course_id = course.cid where course.cname =  '体育' ) as B       on A.student_id = B.student_id where sw >  if(isnull(ty),0,ty); 如果isnull(true)为true时,返回  sw>0  否则 返回  sw> ty;

转载请注明原文地址: https://www.6miu.com/read-81873.html

最新回复(0)