Case用法
摘要:SELECT = CASE WHEN THEN WHEN THEN ELSE END 在上面的代码中需要用具体的参数代替尖括号中的内容。下面是一个简单的例子: USE pubs GO SELECT Title, 'Price Range' = CASE WHEN price IS NULL THEN 'Unpriced' WHEN price < 10 THEN 'Bargain' WHEN price BETWEEN 10 and 20 THEN 'Average' ELSE 'Gift...
阅读全文
posted @ 2013-07-21 15:59