I have a simple table
I want to find the max id for each individual tid in my table.
if I did it one by one it would be:
select max(id) from mytable where tid = 12345;
but how can I do something more like:
select concat(tid,':',id) from mytable where tid in (123,124,125,126);
Above is obviously wrone, because what I want is 1 row for each tid in
my 'in' clause that is the max id for that tid.:
tid:id -> 123:8 for instance.
Maybe a group by or something?