1.從ptt看到選取每個學生日期最新的成績的問題
select * from x b inner join (select max(date)as date,name from x GROUP BY name ) c on b.date=c.date and b.name=c.name
1.從ptt看到選取每個學生日期最新的成績的問題
select * from x b inner join (select max(date)as date,name from x GROUP BY name ) c on b.date=c.date and b.name=c.name
select if(updated_at>created_at,updated_at,created_at) as temp, id from chats order by temp