Pandaaaa906

cnas

Feb 20th, 2021
864
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2. "bigTypeName" "标准大类",
  3. regexp_replace(substring("stdCode", '([A-Za-z]*[\s\\/]?[A-Za-z]?\s?\d+(\.\d+)?[\-::]\d+)'), '[\s/\\]','', 'g') "标准代号" ,
  4.  
  5. count(distinct "branchId") "机构分支数量"
  6. from cnasability
  7. where "stdCode" is not null
  8. group by "bigTypeName", regexp_replace(substring("stdCode", '([A-Za-z]*[\s\\/]?[A-Za-z]?\s?\d+(\.\d+)?[\-::]\d+)'), '[\s/\\]','', 'g')
  9. order by "bigTypeName", 2 desc
RAW Paste Data