Home » RDBMS Server » Server Administration » Re: Alright Smart Guys... Here's a simple one.
Re: Alright Smart Guys... Here's a simple one. [message #372523] Mon, 19 February 2001 09:10
Marcus Fernando
Messages: 34
Registered: September 2000
Member
Ops, i forgot the 3 relationships.

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

Report message to a moderator

Previous Topic: Re: Alright Smart Guys... Here's a simple one.
Next Topic: Indexed columns and order by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 07:39:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.