Re: Ordered Top-N in a subquery

select	*
from	person p,
	personTitle pt
where	p.person_id = pt.id
and	pt.rank =
	(
		select	max(rank)
		from	personTitle pt2
		where	pt.id = p.person_id
	)

Regards,

Pratap Received on Tue Sep 21 2004 - 05:08:52 CDT