27,580
社区成员
发帖
与我相关
我的任务
分享
select City ,GBCode ,substring(GBCode,1,4) as gbcode from public_AddressCity
where gbcode like '3303%' and GBCode<>'330382'
select City ,GBCode ,substring(GBCode,1,4) as gbcode from public_AddressCity
where gbcode like '3303%' and GBCode<>'3303%'
select City ,GBCode ,substring(GBCode,1,4) as gbcode
from public_AddressCity
where left(gbcode, 4) = 3303 and GBCode<>'330382'
SELECT City,
GBCode,
SUBSTRING(GBCode, 1, 4) AS gbcode
FROM public_AddressCity
WHERE gbcode LIKE LEFT('330382', 4) + '%'
AND GBCode <> '330382'