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