用sql的case when语句写出56个民族的替换:1汉族;2蒙古族;3回族4藏族5维吾尔族;6苗族;7彝族;8壮族;9布依族;10朝鲜族;11满族;12侗族;13瑶族;14白族;15土家族;16哈尼族;;17哈萨克族;18傣族;19黎族;20傈僳族;21佤族;22畲族;23高山族;24拉祜族;25水族;26东乡族;27纳西族;28景颇族;29柯尔克孜族;30土族;31达斡尔族;32仫佬族;33羌族;34布朗族35撒拉族36毛南族;37仡佬族;38锡伯族;39阿昌族;40普米族;41塔吉克族;42怒族43乌孜别克族;44俄罗斯族;45鄂温克族;46德昂族;47保安族;48裕固族;49京族;50塔塔尔族;51独龙族;52鄂伦春族;53赫哲族;54门巴族;55珞巴族;56基诺族;97未定族称人口;98入籍
时间: 2023-02-10 21:19:41 浏览: 116
你可以使用以下 SQL 语句来替换这 56 个民族:
```
SELECT
CASE
WHEN nationality = 1 THEN '汉族'
WHEN nationality = 2 THEN '蒙古族'
WHEN nationality = 3 THEN '回族'
WHEN nationality = 4 THEN '藏族'
WHEN nationality = 5 THEN '维吾尔族'
WHEN nationality = 6 THEN '苗族'
WHEN nationality = 7 THEN '彝族'
WHEN nationality = 8 THEN '壮族'
WHEN nationality = 9 THEN '布依族'
WHEN nationality = 10 THEN '朝鲜族'
WHEN nationality = 11 THEN '满族'
WHEN nationality = 12 THEN '侗族'
WHEN nationality = 13 THEN '瑶族'
WHEN nationality = 14 THEN '白族'
WHEN nationality = 15 THEN '土家族'
WHEN nationality = 16 THEN '哈尼族'
WHEN nationality = 17 THEN '哈萨克族'
WHEN nationality = 18 THEN '傣族'
WHEN nationality = 19 THEN '黎族'
WHEN nationality = 20 THEN '傈僳族'
WHEN nationality = 21 THEN '佤族'
WHEN nationality = 22 THEN '畲族'
WHEN nationality = 23 THEN '高山族'
WHEN nationality = 24 THEN '拉祜族'
WHEN nationality = 25 THEN '水族'
WHEN nationality = 26 THEN '东乡族'
WHEN nationality = 27 THEN '纳西族'
WHEN nationality = 28 THEN '景颇族'
WHEN nationality = 29 THEN '柯尔克孜族'
WHEN nationality = 30 THEN '土族'
WHEN nationality = 31 THEN '达斡尔族'
WHEN nationality = 32 THEN '仫佬族'
WHEN nationality = 33 THEN '羌族'
WHEN nationality = 34 THEN '布朗族'
WHEN nationality = 35 THEN '撒拉族'
WHEN nationality = 36 THEN '毛南族'
WHEN nationality = 37 THEN '仡佬族'
WHEN nationality = 38 THEN '锡伯族'
WHEN nationality = 39 THEN '阿昌族'
WHEN nationality = 40 THEN '普米族'
WHEN nationality = 41 THEN '塔吉克族'
WHEN nationality = 42 THEN '怒族'
WHEN nationality = 43 THEN '乌孜别克族'
WHEN nationality = 44 THEN '俄罗斯族'
WHEN nationality = 45 THEN '鄂温克族'
WHEN nationality = 46 THEN '德昂族'
WHEN nationality =