隨便你用哪個SQL@@~我是使用MSSQL

我先放基本資料~你們試試看~

declare @Tmp table(
	StrTmp nvarchar(10)
)

insert into @Tmp
values(Nchar(55357) + Nchar(56374) + N'A' + Nchar(55357) + Nchar(56374))
,(N'ʕ•ﻌ•ʔ')
,(Nchar(55357) + Nchar(56893) +Nchar(55357) + Nchar(56893) +Nchar(55357) + Nchar(56893) +N'ʔʔʔ')
,(Nchar(55357) + Nchar(56374) + N'ʔʔʔ' + Nchar(55357) + Nchar(56374))
,(N'ﻌﻌﻌ')

結果如圖下~

補充~沒想到IT邦~不支援貼特殊符號....= =||
先幫特殊符號編碼~

這部分我是用T-SQL來辦@@~看大家有無更好的方式~明天按解答結束~

declare @TmpAns table(
	StrTmp nvarchar(10)
	,UnicodeNum int
)

declare @i int=0,@Count int=0,@Str nvarchar(50)=''
select @Count=Count(0)
from @Tmp

declare @j int=0,@SubCount int=0

while(@i<@Count)
begin
	set @i = @i + 1

	select @Str=StrTmp
	from (
		select Row_Number()Over(order by StrTmp) Sort
		,StrTmp
		from @Tmp
	) k
	where Sort = @i

	set @j = 0
	set @SubCount = len(@Str)
	while(@j<@SubCount)
	begin
		set @j = @j + 1
		if(UNICODE(SUBSTRING(@Str,@j,1))=55357)
		begin
			insert into @TmpAns
			values(SUBSTRING(@Str,@j,2),UNICODE(SUBSTRING(@Str,@j,1)) + UNICODE(SUBSTRING(@Str,@j + 1,1)))
			set @j = @j + 1
		end
		else
		begin
			insert into @TmpAns
			values(SUBSTRING(@Str,@j,1),UNICODE(SUBSTRING(@Str,@j,1)))
		end
	end

end

select StrTmp
,Count(0) Num
from @TmpAns
group by StrTmp
,UnicodeNum
order by StrTmp

再次改良一次~這個就是用SQL去查詢了@@"

select StrShow
,Count(0) Num
from (
	select StrTmp
	,(
		case when UNICODE(SUBSTRING(StrTmp,Sort,1)) = 55357
		then SUBSTRING(StrTmp,Sort,2)
		else case when UNICODE(SUBSTRING(StrTmp,Sort,1)) not between 55357 and 60000 then SUBSTRING(StrTmp,Sort,1) else '' end
		end
	) StrShow
	,(
		case when UNICODE(SUBSTRING(StrTmp,Sort,1)) = 55357
		then UNICODE(SUBSTRING(StrTmp,Sort,1)) + UNICODE(SUBSTRING(StrTmp,Sort + 1,1))
		else case when UNICODE(SUBSTRING(StrTmp,Sort,1)) not between 55357 and 60000 then UNICODE(SUBSTRING(StrTmp,Sort,1)) else 0 end
		end
	) StrNum
	from @Tmp
	,(
		select Row_Number()Over(order by [number]) as Sort
		from master..spt_values
	) as k
	where Sort <= len(StrTmp)
) k
where len(StrShow) > 0
group by StrShow
,StrNum
order by StrShow

6/30更新

根據rogeryao提供字元補充字符定序後
Latin1_General_100_CI_AS_SC

這次查詢就沒有字元長度問題了~

select StrShow
,count(0) Num
from (
	select SUBSTRING(StrTmp collate Latin1_General_100_CI_AS_SC,Sort,1)StrShow
	from @Tmp
	,(
		select Row_Number()Over(order by [number]) as Sort
		from master..spt_values
	) as k
	where Sort <= len(StrTmp collate Latin1_General_100_CI_AS_SC)
) k
group by StrShow
order by StrShow desc

使用定序總類參考：
https://docs.microsoft.com/zh-tw/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15