OraFAQ Forum: Server Administration » Re: Alright Smart Guys... Here's a simple one.

Home » RDBMS Server » Server Administration » Re: Alright Smart Guys... Here's a simple one.

Mon, 19 February 2001 09:01

Marcus Fernando
Messages: 34
Registered: September 2000

Member

select d.girl, d.datenum, d.guy
from dates d
where d.datenum = (select max(datenum)
from dates e
where e.girl=d.girl)

Previous Topic:	sequel related
Next Topic:	Re: Alright Smart Guys... Here's a simple one.

Goto Forum:

]

Current Time: Fri Jan 24 06:27:51 CST 2025