Category "groupwise-maximum"

why is this sql not using index with date type column

mysql:5.7/8.0 table ddl -- auto-generated definition create table test_date_index ( id int auto_increment primary key, account_id int not null, re

get latest record for each ID

I would like to get the latest record for each server. Here is some example data: TimeGenerated SourceName ComputerName Message 2014-11-22

get latest record for each ID

I would like to get the latest record for each server. Here is some example data: TimeGenerated SourceName ComputerName Message 2014-11-22