（大佬們）現想根據紅色框里欄位去重， 去重后只顯示紅色框里的欄位行的資料
需要怎么改？
select
MAX(a.item_name) as item_name,
c.register_id,
c.measure_value,
c.record_date,
c.measure_value2,
c.lastmodify_time
from re_threeitem_monitordata as c
left join re_threeitem_monitordata_type a on a.item_code =c.measure_type
where register_id=32387
group by item_name,c.register_id,
c.measure_value,
c.record_date,
c.measure_value2,
c.lastmodify_time,serno_int
order by record_date
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/232794.html
標籤：疑難問題
上一篇：mysql問題