长期潜伏,第一次在这里张贴海报。
我的问题是,下面的sql查询返回重复的行:
select
inv.i4201 as pmid,
inv.i4235 as calPlace,
inv.i4204 as device,
inv.i4203 as type,
inv.i4202 as manufacturer,
inv.i4206 as serialNumber,
cal.c2323 as condition,
inv.i4299 as availability,
inv.i4236 as dateRegistration,
max(cal.c2301) as dateCalibration,
inv.i4229 as interval,
max(cal.c2303) as dateExpiry,
inv.i4228 as intervallType,
loc.l2803 as costCenter,
inv.i4242 as location,
cust.k4601 as CustomerNumber,
cust.k4602 as CustomerName
from
inventory inv
join customers cust on inv.ktag = cust.ktag
join calibration cal on inv.mtag = cal.mtag
join location loc on inv.mtag = loc.mtag
where CustomerName like 'xxx%' and device like 'yyy%'
group by
pmid,
calPlace,
device,
type,
manufacturer,
serialNumber,
condition,
availability,
dateRegistration,
interval,
intervallType,
costCenter,
location,
CustomerNumber,
CustomerName
order by pmid;如何使用最新的dateCalibration和/或dateExpiry只为每个pmid获取一行?
https://stackoverflow.com/questions/47656518
复制相似问题