On Mon, 2005-08-22 at 16:54 -0600, Dennis Cote wrote: > select * > from MyTable > join (select random(*) as number) as rand > where start_col >= rand.number > and end_col < rand.number; >
Very nice. Dennis Cote wins todays prize for cleverest use (abuse?) of a join! -- D. Richard Hipp <[EMAIL PROTECTED]>
