I have 2 tables segments and summaries.
I want to list the shows in a date interval and just show the latest updated segments (in bold) since it is the freshest copy of the segment for that person.
Here is the query I used to have the result below:
select seg.summ, su.channel, seg.block_id, seg.person, seg.updated_at as segupdate
from segments seg
left join summaries su on seg.summ = su.id
where su.created_at between '2018-06-06' and '2018-07-13'
order by summ, block_id, seg.updated_at desc;
I want this:
How can I get change my query to show just the bolded rows? to remove the duplicates that are an older version?