mssql2000判断所有列大于等于某列值_Sql Server

mssql2000判断全部列大于等于某列值
mssql2000判断全部列大于等于某列值
billid,qty,exeqty
1001, 300, 200
1001, 350, 350
1001, 700 ,750

1001, 600, 700
1001, 350, 350
1001, 700 ,699 ----这是没有超或等于699

要求结果:判断同一BILLID，当exeqty全部都大于或等于qty的数据

billid,qty,exeqty,
1001, 300, 200
1001, 350, 350
1001, 700 ,750

------解决方案--------------------

SQL code

select BILLID,       qty,       exeqty       from tab a  inner join tab b on a.BILLID=b.BILLID where a.exeqty>b.qty--你需要的结果应该是/*billid   qty    exeqty1001     600     7001001     350     3501001     700     750*/
------解决方案--------------------
select * from tb a where a.exeqty>=a.qty and  not exist(select 1 from tb b where a.billid=b=billid and b.exeqty<b.qty )