我有一个包含日期字段和记录ID字段的表。recordid字段有10001 10002 11152等记录。这些id根据日期字段重复。我想提取每个记录ID一次,并指定该记录ID的最长日期。
SELECT recordid, MAX(Date) From yourTable
GROUP By recordid
SELECT recordid,MAX(date) FROM table GROUP BY recordid;
使用MAX
并按recordid
分组
SELECT recordid
,MAX(date)
FROM your_table
GROUP BY recordid
这就是你想要的吗?
Select *
from your_table
inner join (
SELECT recordid, date=MAX(Date) From yourTable
GROUP By recordid) as m
on your_table.recordid=m.recordid
怎么样
select * from your_table where date = (select max(date) from your_table yt)