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;

建议：将两个表的表结构写出来。再写一些模拟数据，以及预期结果