Max value in v_codevalue_web

PHOTO EMBED

Tue Sep 13 2022 16:03:16 GMT+0000 (UTC)

Saved by @statu7 #sql

SELECT MAX(to_number(regexp_substr(cv.CODEMNEMONIC, '[0-9]*$')))
  FROM v_codevalue_web_codes_full cv
 WHERE cv.CODEVALUENAME LIKE 'Alipay%'
   AND cv.DOMAINNAME LIKE 'ClgSys';
content_copyCOPY