表分割读取

'--' as  custom  --该字段的名称是custom,值是默认值--
name as userName --该字段的名称是userName,值是实际值

select * from  (
    select cast(<name> as varchar) as userName, cast(id as varchar) as userID ,...,<address> as userAddress from <schema>.<table> where <condition>
) a where abs(mod(hashtext(a._bh),5))=1

 

posted @ 2020-07-20 10:12  阿布都日  阅读(90)  评论(0编辑  收藏  举报