sample76.sql

来自「T-SQL示例大全」· SQL 代码 · 共 20 行

/* 文件名称: Sample76.sql */
USE pubs

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
FROM authors
ORDER BY au_lname