1. select field1, 2. (case 3. when condition then dosomthing 4. when condition then dosomthing 5. else dosomthing 6. end) fieldname 7. from tablename 8. 9. --或者在products、tigger和function中也可以使用