62,244
社区成员




select countrycode, (SELECT top 1 substring(countrycode,1,3))as code_name,(SELECT top 1 substring(countryname,1,charindex(' ',countryname)-1))as chn_name,(SELECT top 1 substring(countryname,charindex(' ',countryname)+1,40)) as eng_name FROM tbflightscountry
大家帮忙看看这个语句有什么问题好吗?非常感谢