0642641垢版 | 大砲2018/11/29(木) 11:26:02.69ID:??? 違った、こうか? select a.name, a.date, a.rate from hoge as a, (select name, MAX(date) from hoge where rate < 1000 group by name, date) as b where a.name = b.name and a.date=b.date;