mysql，cha询问题

q2012q01 · 发表于 2024-8-3 22:49:56

cha询每个账号ID的，投资的总价，以及变现的总价，这个要怎么写？

baitso · 发表于 2024-8-3 22:49:57

Select ISNULL(A.账号ID,B.账号ID),ISNULL(A.投资总价,0),ISNULL(B.变现总价,0) From (Select 账号ID, sum(总价) as 投资总价 From [表名] where 类型 = '投资' Group by 账号ID ) as A full outer Join (Select 账号ID, sum(总价) as 变现总价 From [表名] where 类型 = '变现' Group by 账号ID ) as B on A.账号ID = B.账号ID

没事瞎琢磨 · 发表于 2024-8-3 23:05:08

你就直接查id 他就出现当前id的所有数据都取出来在判断分一下

15039346689 · 发表于 2024-8-3 23:13:43

https://www.eyuyan.la/post/2618.html

suyunsq · 发表于 2024-8-3 23:14:32

最近老有人问的mysql数据库cha询、修改、删除
https://bbs.125.la/forum.php?mod=viewthread&tid=13962610
(出处: 精易论坛)
你如果是想问方法，那就参照上面的帖子

勉勉 · 发表于 2024-8-3 23:18:10

php 还是易？ php用mysqli 易用mysql连接池

baitso · 发表于 2024-8-3 23:19:04

Select A.账号ID,A.投资总价,B.变现总价 From (Select 账号ID, sum(总价) as 投资总价 From [表名] where 类型 = '投资' Group by 账号ID ) as A Left Join (Select 账号ID, sum(总价) as 变现总价 From [表名] where 类型 = '变现' Group by 账号ID ) as B on A.账号ID = B.账号ID

q2012q01 · 发表于 2024-8-3 23:38:44

baitso 发表于 2024-8-3 23:19
Select A.账号ID,A.投资总价,B.变现总价 From (Select 账号ID, sum(总价) as 投资总价 From [表名] where ...

只能cha询出1个结果

q838210720 · 发表于 2024-8-4 00:58:04

你这个问题问ai保证比我们这些回答都专业

		自动登录	找回密码
密码			注册

[已解决] mysql，cha询问题

最佳答案

评分