SQL Basic Operation--case End

Case end for multi-conditional judgment

-- View Person Table Select *  from Person

--make conditional judgments on the math fieldSelectName, Math score= Case     whenMath> -  Then 'Excellent'     whenMath> -  Then 'Liang'     whenMath> the  Then 'in'     whenMath> -  Then 'Pass'     whenMath is NULL  Then 'Lack of test'    Else 'inferior lattice'End fromPerson

Results:

-- Query T8 Table Select *  from T8

-- determine the size of the values of two adjacent tables Select maximum values in columns A and B =  Case     when A>thenelse  bend, the maximum value in columns B and c =case when     B>thenelse  Cendfrom T8

Results:

SQL basic Operation--case end