查出存货表中 ID 值最大的业务对应的字段的值
select id,cinvcode,fprice,ccurrency from StProducts t1 where id = (
select max(id) as ID from StProducts where cinvcode=t1.cinvcode
group by cinvcode,ccurrency)
查出存货表中 ID 值最大的业务对应的字段的值
select id,cinvcode,fprice,ccurrency from StProducts t1 where id = (
select max(id) as ID from StProducts where cinvcode=t1.cinvcode
group by cinvcode,ccurrency)