SQL CASE WHEN 语句:
SELECT s.school_id, s. NAME, s.school_type, ( CASE s.school_type WHEN 3 THEN 'aa' WHEN 2 THEN 'bb' END ) 自定义 FROM franchised_school_info s
SQL CASE WHEN 语句:
SELECT s.school_id, s. NAME, s.school_type, ( CASE s.school_type WHEN 3 THEN 'aa' WHEN 2 THEN 'bb' END ) 自定义 FROM franchised_school_info s
转载于:https://www.cnblogs.com/wangfeihu/p/11388904.html