bmgroup數字貨幣官網

A. SQL如何分類後順序連接字串

----以下在sql2005測試通過。

create table table1(bm varchar(10),ry varchar(10),mas varchar(10))
insert table1
select 'org1','sta1','mas' union all
select 'org1','sta2','' union all
select 'org1','sta3','' union all
select 'org2','sta4','mas' union all
select 'org2','sta5',''

---以前就回答過這樣的問題了，給你2個參考方案：
--實現方式1、利用函數
--分析，可以按照ID進行分組，然後對每個ID的value進行函數合並。
if object_id(N'dbo.f_str',N'FN') is not null
drop function dbo.f_str
go
CREATE FUNCTION dbo.f_str(@bm varchar(10))
RETURNS varchar(1000)
AS
BEGIN
DECLARE @r varchar(1000)
SELECT @r = isnull(@r+';','')+ry FROM table1 WHERE bm=@bm
RETURN @r
END
GO
-- 調用函數
select * from(select bm,mas from table1 where (mas<>'' and not mas is null))t1
outer apply
(
SELECt [ry] = dbo.f_str(bm) FROM table1 where t1.bm=bm group by bm
)t2

--實現方式2、利用group by和for XML
--利用for XML構造每個ID的vlaue合並，然後和ID列進行合並
--這里只是用了group by進行分組
select * from(select bm,mas from table1 where (mas<>'' and not mas is null))t1
outer apply
(select [ry]=stuff((select ';'+ry from table1 where bm=t2.bm for xml path('')), 1, 1, '')
from table1 t2 where t1.bm=bm
group by bm
)t3

--樓主滿意了沒。

B. BMgroup數字貨幣不能出金怎麼辦像是被騙了！

虛假平台的，提現不出，及時提供相關轉賬證據可以維權處理，我和朋友就是輕信被騙了，還好在通過法援的幫助下維權解決挽回全部的損失了，真的是萬分感謝他們

C. SOL語句的查詢與優化

SELECT TABLE1.ID,
'0' AS ZFY,
SUM(TABLE1.SL * TABLE1.JG) AS WPF,
TABLE2.MC,
TT.ZFY 'ZongFeiYong'
FROM TABLE1,
TABLE2,
(SELECT TABLE1.ID,
SUM((TABLE1.SL * TABLE1.JG) + (TABLE1.XJJE + TABLE1.JZJE) / 2) AS ZFY
FROM TABLE1
GROUP BY TABLE1.ID) TT
WHERE TABLE2.BM = TABLE1.PMBM
AND TABLE1.ID = TT.ID
AND ZXSJ >= '2011-10-01'
AND ZXSJ < '2011-10-03'
AND TABLE2.BM = BQ_YZZXMX_CY.PMBM
AND TABLE2.WPFLBM IN ('x01', 'x10', 'x11', 'x12', 'x13')
GROUP BY TABLE1.ID, TABLE2.MC, TT.ZFY;

建議：將兩個表的表結構寫出來。再寫一些模擬數據，以及預期結果