By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table pricing
(
debtor_code int,
stock_code varchar(20),
min_quantity int,
default_price decimal(10,2),
contract_price decimal(10,2)
)
insert into pricing values
(2393, 'GRBAG100GTALL-50', 0, 295, 236.00),
(2393, 'GRBAG100GTALL-50', 5, 295, 265.50),
(2393, 'GRBAG100GTALL-50', 10, 295, 221.25);
3 rows affected
with cte as
(
select *,
case when lead(contract_price) over (partition by debtor_code
order by min_quantity) < contract_price
then 1
else 0
end as flag
from pricing
)
select *
from cte
where flag = 0
| debtor_code | stock_code | min_quantity | default_price | contract_price | flag |
|---|---|---|---|---|---|
| 2393 | GRBAG100GTALL-50 | 0 | 295.00 | 236.00 | 0 |
| 2393 | GRBAG100GTALL-50 | 10 | 295.00 | 221.25 | 0 |