Sql Server È¥Öظ´Êý¾Ý

ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»¸öOrder±í ÀïÃæ×Ö¶ÎΪ
orderId amount qty
100100 -100 -1
100100 100 1



ÏÖÔÚ ÎÒÏë²éѯʱ È¥µôÕâÁ½ÌõÊý¾Ý ²»ÊÇɾ³ý Ö»ÊÇÏë²éѯʱ½«ÕâÁ½ÌìÊý¾ÝͬʱÌÞ³ý

---

Á½Ìõ¶¼È¥µô??

---

SQL code:
select *
from [Order] t
where exists(select 1
from [Order]
where orderId=t.orderId
group by orderId having count(*)=1)

---

select * from Order
where orderId<>100100 and (( amount<>-100 andqty<>-1) 
or (amount<>100 andqty<>1))

---

Á½Ìõ¶¼È¥µô??

---

SQL code:
select * from Order group by orderId,amount,qty having count(*)=1

---

select * from tb t where not exists(select 1 from tb where (orderId=t.orderId and t.amount<>amount) or (orderId=t.orderId and amount<>t.amount))

---

SQL code:
select * from Order a
where not exists(select 1 from Order where a.orderId=orderId group by orderId having count(*)>=2)

---

SQL code:
select order