select X.id, X.name, Y.title from work X, (select work,title FROM comments a WHERE a.rowid = (SELECT max(b.rowid) FROM comments b WHERE a.work= b.work) ) Y where X.id=Y.work(+);可以考虑将Y写成视图
谢谢提供思路,把Max改成Min,搞定了。就是想把结果写成视图方便在程序中访问的:) select X.id, X.name, Y.title from work X, (select work,title FROM comments a WHERE a.rowid = (SELECT Min(b.rowid) FROM comments b WHERE a.work= b.work) ) Y where X.id=Y.work(+) Order By x.Id Desc;
from work X,
(select work,title FROM comments a WHERE a.rowid = (SELECT max(b.rowid) FROM comments b WHERE a.work= b.work) ) Y
where X.id=Y.work(+);可以考虑将Y写成视图
select X.id, X.name, Y.title
from work X,
(select work,title FROM comments a WHERE a.rowid = (SELECT Min(b.rowid) FROM comments b WHERE a.work= b.work) ) Y
where X.id=Y.work(+) Order By x.Id Desc;