SQLServer(二) Case When
                        
                            时间:2021-07-01 10:21:17
                            帮助过:4人阅读
							                        
                     
                    
                    
                     
id,
case id 
when ‘6‘ then ‘six‘
when ‘7‘ then ‘seven‘
when ‘8‘ then ‘eight‘
else ‘other‘
end as id_type
from formtable_main_122 
where id 
= 7
 
SQLServer(二) Case When
标签:sel   type   sql   lse   sqlserver   end   div   other   span