有一个库kc.dbf内有两个字段,货物编号(BH)及

2025-04-14 15:35:24
推荐回答(1个)
回答1:

好帖
很好帖
确实好贴
非常好的贴
他吗的是好贴
真是难得的好贴

select DJ*number(mount) from yourtable where BH=yourid;
select mount*0.9(nithdiscount) from yourtable where mount>1000 AND mount<5000;

select mount*0.8(eithdiscount) from yourtable where mount>5000;