摘要: 语句:case when expression then ... else ... end;SELECT Name, Dept, Address..street, Address..number, Address..city, Address..state, CASE WHEN Address IS OF (US_addr_t) THEN TREAT(Address AS US_addr_t)..zip WHEN Address IS OF (Germany_addr_t) THEN TREAT (Address AS Germany_addr_t)..family_name WHEN A.. 阅读全文
posted @ 2011-11-24 12:34 琥珀光 阅读(412) 评论(0) 推荐(0) 编辑