Skip to main content
Ben Nadel at InVision In Real Life (IRL) 2019 (Phoenix, AZ) with: Ben Michel and Boaz Ruck
Ben Nadel at InVision In Real Life (IRL) 2019 (Phoenix, AZ) with: Ben Michel ( @obensource ) Boaz Ruck

samraj

Member since Sep 27, 2009

Recent Blog Comments By samraj

  • Getting Group By Count In Left Outer Join

    Posted on Sep 27, 2009 at 1:38 AM

    rewrite the given query without using join and group by select b.title,max(bc.returneddate-bc.checkoutdate) ''most days out'' from bookshelf_checkout bc,bookshelf b where bc.title(+)=b.title group by b.title;... read more »