PostgreSQL的:其他领域
问题描述:
我想选择最新的(order by id desc
)唯一对date_start, date_finish
PostgreSQL的:其他领域
CREATE TABLE some (
id SERIAL,
date_start TIMESTAMP,
date_finish TIMESTAMP
);
答
选择唯一对顺序如何:
select date_start, date_finish
from some
group by date_start, date_finish
order by max(id) desc
+0
是的,就是这样!谢谢! –
你能提供的样本数据和预期的结果? – sgeddes