在 sqlite 中检索最新日期的记录

Question

我在SQLite3中price_date了这个表。

id    info_id       price       date
"661"   "1"         "15.99"     "2018-10-15"
"1334"  "1"         "18.52"     "2018-10-01"
"439"   "2"         "24.48"     "2018-10-15"
"1113"  "2"         "25.97"     "2018-10-01"
"2"     "6"         "0.64"      "2018-10-15"
"678"   "6"         "0.66"      "2018-10-01"

我想检索具有最新日期的记录，以便输出如下所示;

id    info_id       price       date
"661"   "1"         "15.99"     "2018-10-15"
"439"   "2"         "24.48"     "2018-10-15"
"2"     "6"         "0.64"      "2018-10-15"

关于开始编写 sql 代码的任何提示？

Answer 1

使用相关子查询

select * from price_date t 
where t.date = 
( select max(date) from price_date t1 
where t1.info_id=t.info_id
)

Answer 2

使用相关子查询

select * from tablename t1 where date in
(select max(date) from tablename t2 where t1.info_id=t2.info_id)