摘要:
1.根据生日查询年龄 SELECT YEAR(CURDATE())-YEAR(birthDate)-(RIGHT(CURDATE(),5)<RIGHT(birthDate,5)) FROM 表名 a WHERE a.`uid` IN(159486); 与上面的结果相等sql: SELECT TIME 阅读全文
摘要:
case when两种语法及与聚合函数使用:1.SELECT CASE WHEN a.`accountChannel` = 'BSR' THEN 'XX银行' WHEN a.`accountChannel` = 'BGZ' THEN 'XX银行' WHEN a.`accountChannel` = 阅读全文