Home » RDBMS Server » Server Administration » Re: Alright Smart Guys... Here's a simple one.
Re: Alright Smart Guys... Here's a simple one. [message #372517] Sat, 17 February 2001 13:58
amarpatgiri
Messages: 11
Registered: December 2000
Junior Member
How about this one?

select girl,decode(max(datenum),1,max(datenum),2,max(datenum),3,max(datenum),3)
from dates
group by girl

No wonder with 4 girls in the house you find it hard to figure out :-)

-amar

Report message to a moderator

Previous Topic: Re: Alright Smart Guys... Here's a simple one.
Next Topic: better way to do this
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 08:10:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.