sql½ØÈ¡ Êý×ÖÎÊÌâ

SQL code:
if object_id('tb') is not null drop table tb

create table tb
(col varchar(50))

insert into tb
select '²âÊÔ£¨ÏîÄ¿1£©µÚ£¨1£©ÆÚ' union all
select '²âÊÔ£¨ÏîÄ¿1£©µÚ£¨3£©ÆÚ' union all
select '²âÊÔ£¨ÏîÄ¿1£©µÚ£¨4£©ÆÚ' union all
select '²âÊÔ£¨ÏîÄ¿1£©µÚ£¨52£©ÆÚ' union all
select '²âÊÔ£¨ÏîÄ¿2£©µÚ£¨26£©ÆÚ' union all
select '²âÊÔ²âÊÔ£¨ÏîÄ¿2£©µÚ£¨3£©ÆÚ'

select * from tb

select Max(cast(substring(col,len(col)-2,1)as int)) from tb
--ÉÏÃæÕâÌõÓï¾ä£¬ÎÒµÄÄ¿µÄÕÒ³öËùÓÐÏîÄ¿µÄ×î´óÆÚÊý£¬µ«ÊÇÓеÄÊÇÁ½Î»Êý£¬»òÕ߶àÓÚÁ½Î»Êý£¬ÕâÌõÓï¾ä¿Ï¶¨²»¶ÔÇëÎÊÔõôÐÞ¸Ä

select substring(col,charindex('200',col),4),max(cast(substring(col,charindex('(',col)+1,charindex(')',col)-charindex('(',col)-1) as int)) from tb
group by substring(col,charindex('200',col),4)

--ÉÏÃæÕâÌõÓï¾ä£¬ÎÒµÄÄ¿µÄÊÇ Çó³ö¶ÔÓ¦ÏîÄ¿µÄµÄ×î´óÆÚÊý£¬½ØÈ¡×Ö·û¡£µ«ÓÉÓÚÇ°ÃæÒѾ­ÓÐÁË¡®£¨¡¯£¬¡®£©¡¯ÕâÁ½¸ö·ûºÅ£¬ËùÓнØÈ¡µÄ·½·¨¿Ï¶¨Ò²²»¶Ô£¬ÇëÎÊÈçºÎÐÞÕý

---

SQL code:
--1
select max(substring(col,charindex('µÚ£¨',col)+2,charindex('£©ÆÚ',col)-2-charindex('µÚ£¨',col)))
from tb

---

SQL code:
--2
select
substring(col,charindex('£¨',col)+1,charindex('£©',col)-1-charindex('£¨',col)