一道题！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！

2007-01-30 09:09:51 340 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Winform利用动画控制实现各种特效动画绘制控制类代码 using System; using System.Drawing; using System.Drawing.Drawing2D; using System.Drawing.Imaging; using System.Threading; using System.Windows.Forms; namespace Mengliao.CSharp.A14 { #region 动画类型枚举 // 本例为了简单起见没有使用见名知意的名称，如用于实际可将这些枚举成员更名阅读详情

表A,B 有著相同的結構字段分別為：ID, AMOUNT（字段类型是数字）。B表中的ID是主键。
表A

ID Amount

表B
ID(主键) Amount

請用一個SELECT語句返回滿足以下要求的數據集。
返回表A所有的ID、返回的字段包括：
ID,
A_AMOUNT(A表中相同ID的AMOUT的和)，
B_AMOUNT(B中對應ID的AMOUNT的值)，
STATUS(如果A_AMOUNT和B_AMOUNT的值相同為'OK',否則為"NG")

...全文

传统（经典）粒子群算法（PSO）解决单目标优化问题智能算法：粒子群算法（particle swarm optimizer）—PSO %原理：（1）种群初始化–N(种群数)–D(个体数)–x(i)(粒子位置)–v(i)(粒子速度) % （2）计算每个粒子的适应度值–而适应度值需要选择适应度函数 % （3）对于每个粒子，使用它的适应度值fit[i]和个体的极值pbest(i)进行比较，如果fit[i]>pbest(i),则pbest(i)=fit[i] % (4)同理，对每个粒子用它的适应值与全局极值进行比较，如果比它大，则阅读详情

wxylvmnn

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

xiaoku 2007-01-31

打赏
举报

select t.id ,t.A_AMOUNT A_AMOUNT,b.Amount as B_AMOUNT
,case when t.A_AMOUNT = b.Amount then 'OK' else 'NG' end as STATUS
from
(
select ID ,sum (AMOUNT) as A_AMOUNT
from A
group by ID
) t
left join b on t.id =b.id

xiaoku 2007-01-31

打赏
举报

wxylvmnn 2007-01-31

打赏
举报

s_hluo(笨笨熊) 的答案也不对。

wxylvmnn 2007-01-31

打赏
举报

谢谢 marco08(天道酬勤)的回答。

强调A没有主键，如果有重复的数据，按照你的sql，会冲洗掉重复的数据。

所以，也不对。

marco08 2007-01-30

打赏
举报

--try

select tmpA.*, B_AMOUNT=isnull(B.Amount, 0),
STATUS=case when tmpA.A_AMOUNT=isnull(B.Amount, 0) then 'OK' else 'NG' end
from
(
select ID, A_AMOUNT=sum(Amount)
from A
group by ID
)tmpA
left join B on tmpA.ID=B.ID

s_hluo 2007-01-30

打赏
举报

select T1.ID, A_AMOUNT, B_AMOUNT, case
when A_AMOUNT = B_AMOUNT then 'OK'
else 'NG'
end as STATUS
from
(select ID, sum(a.Amount) as 'A_AMOUNT' from TableA a group by a.ID )as T1
inner join
(select ID, sum(b.Amount) as 'B_AMOUNT' from TableB b group by b.ID)as T2
on T1.ID = T2.ID

wxylvmnn 2007-01-30

打赏
举报

不好意思，好像都不对哈

s_hluo 2007-01-30

打赏
举报

select a.ID, A_AMOUNT, B_AMOUNT, case
when A_AMOUNT = B_AMOUNT then 'OK'
else 'NG'
end
(select ID, sum(a.Amount) as 'A_AMOUNT' from TableA a group by a.ID )as T1
inner join
(select ID, sum(b.Amount) as 'B_AMOUNT' from TableB b group by b.ID)as T2
on T1.ID = T2.ID

leo_lesley 2007-01-30

打赏
举报

select a.id,A_AMOUNT = sum(a.Amount),B_AMOUNT = max(b.AMOUNT),
STATUS = case when sum(a.Amount)= max(b.AMOUNT) then 'OK' else 'NG end
from 表A a , 表B b
where a.id = b.id
group by a.id

rookie_one 2007-01-30

打赏
举报

select A.ID,sum(A.AMOUNT) A_AMOUNT,B.AMOUNT B_AMOUNT,
case sum(A.AMOUNT) when B.AMOUNT then 'OK' else 'NG' end STATUS
from A,B
where A.ID=B.ID
group by A.ID,B.AMOUNT

rookie_one 2007-01-30

打赏
举报

select A.ID,A.AMOUNT A_AMOUNT,B.AMOUNT B_AMOUNT,
case A.AMOUNT when B.AMOUNT then 'OK' else 'NG' end STATUS
from A,B
where A.ID=B.ID

realfool 2007-01-30

打赏
举报

(select A1.id,A1.amount,A2.amount,'OK' from
(select id,sum(amount) as amount from A group by id) as A1 ,
(select id,amount from B ) as A2
where A1.id = A2.id and A1.amount = A2.amount ) union
(select A1.id,A1.amount,A2.amount,'NG' from
(select id,sum(amount) as amount from A group by id) as A1 ,
(select id,amount from B ) as A2
where A1.id = A2.id and A1.amount <> A2.amount )

一道题！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！

相关推荐