SQL質疑応答スレ 18問目

[0643 NAME IS NULL 2018/11/29(木) 13:04:58.18 ID:???]

SELECT * FROM a WHERE (name,date) IN (SELECT name,MAX(date) FROM a GROUP BY name) AND rate<1000