Sep
25
考虑到数据优化，现将千万级数据作分表存储便与查询
sql如何查找出number中第一位为1的数据：
标准写法：
select substring(cast(adv_id as varchar) from 1 for 1) as a1 from zhoz_sub_dat_6_3;
常规写法：
select substring(cast(adv_id as varchar), 1,1) as a1 from zhoz_sub_dat_6_3;
INSERT INTO zhoz_sub_dat_6_3
sql如何查找出number中第一位为1的数据：
标准写法：
select substring(cast(adv_id as varchar) from 1 for 1) as a1 from zhoz_sub_dat_6_3;
常规写法：
select substring(cast(adv_id as varchar), 1,1) as a1 from zhoz_sub_dat_6_3;
INSERT INTO zhoz_sub_dat_6_3
