问答详情
源自:6-12 case...when语句

帮帮忙,谢谢

select entrylane case

when entrylane<=10 then '普通车',when entrylane>10 then '专用车道' end as '车道分类'

  from exit2015070020203;

未找到from的关键字


提问者:qq_无言_51 2016-08-15 10:47

个回答

  • yan_muke
    2016-08-15 14:21:15

    select  entrylane

             , case

                   when entrylane<=10 then '普通车'

                   when entrylane>10 then '专用车道' 

                   end as '车道分类'

      from exit2015070020203;