create table plat_uidlist(Uidd varchar(15) , Areaid int , State int)
insert into plat_uidlist values('2335435' ,8 ,0 )
insert into plat_uidlist values('2335436' ,8 ,1 )
insert into plat_uidlist values('2335437' ,2 ,2 )
insert into plat_uidlist values('2335438' ,8 ,3 )
insert into plat_uidlist values('2335439' ,3 ,0 )
insert into plat_uidlist values('2335440' ,8 ,0 )
insert into plat_uidlist values('6677889' ,8 ,0 )
insert into plat_uidlist values('1234578' ,4 ,0 )
insert into plat_uidlist values('4980010' ,8 ,0 )
insert into plat_uidlist values('4980099' ,8 ,0 )
--如何查询test值3位尾数以上是一样的,如尾数是8888,7777,888,777
select *
from plat_uidlist
where replicate(RIGHT(Uidd,1),3)=RIGHT(Uidd,3)
select * from plat_uidlist where abs(RIGHT(Uidd,2)*1-LEFT(RIGHT(Uidd,4),2)*1)=22
-- 后4位ABCD或者DCBA
select * from plat_uidlist where abs(RIGHT(Uidd,4-1)*1-LEFT
SQL SERVER 手机选号(AABB、ABCD、DCBA、AAA)
最新推荐文章于 2023-08-10 11:52:07 发布
本文介绍如何在SQL SERVER中利用编程方式(如INSERT语句)生成并插入遵循特定模式(如AABB、ABCD、DCBA、AAA)的手机号码,适用于批量生成测试数据或特殊需求场景。
摘要由CSDN通过智能技术生成