SQL之casewhenthen用法_之二

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

select CustomerNo,

       Name,

       Sex,

       Birthday,

       IDType,

       IDNo,

       validityday,

       case (null

            )

         when &＃39;1&＃39; then

          &＃39;高级VIP&＃39;

         when &＃39;2&＃39; then

          &＃39;顶级VIP&＃39;

         else

          &＃39;一般客户&＃39;

       end

  from LDPerson

 where 1 &＃61; 1

 order by CustomerNo