玩一下 create table c260216a ( id int generated always as identity primary key ,...
用 TSQL CTE 跑遞迴,參考看看 CREATE TABLE Temp ( menu smallint , option_type char(1) ,...
記得 RANK(Value) WITHIN GROUP (...) 可以把某個值放到特定群中取得排名這樣就可以解出 select val as 排骨組val,...
c
Like 我 Like 我