(ceos) would want to heavy, according to the field in the red box to display only the fields in the red box after heavy lines of data
What would need to change?



Select
MAX (Anderson tem_name) as item_name,
C.r egister_id,
C. easure_value,
C.r ecord_date,
C. easure_value2,
C.l astmodify_time
The from re_threeitem_monitordata as c
Left the join re_threeitem_monitordata_type on Anderson, a tem_code=c. easure_type
Where register_id=32387
Group by item_name, c.r egister_id,
C. easure_value,
C.r ecord_date,
C. easure_value2,
C.l astmodify_time, serno_int
The order by record_date