Re: SQL Challenge

From: RAVICHANDRAN <ravis_at_gto.net.om>
Date: Thu, 21 Oct 1999 11:41:31 +0400
Message-ID: <7und6g$h801@OM9.omantel.net.om>

RAVICHANDRAN <ravichandren_at_hotmail.com> wrote in message news:7unc87$h7r2_at_OM9.omantel.net.om...
> Hi! Here is my simple solution in SQL*Plus.
> I wonder whether this works fine with DB2!
> SQL> BREAK ON CATEGORY
> SQL> SELECT * FROM SAMPLE ORDER BY CATEGORY;
>
> CATEGORY ITEM
> -------- ---------------
> LAMP 40W
> 60W
> 100W
>
> TOOL POWER MITER
> BAND SAW
> TABLE SAW
> SCROLL SAW
> WOOD OAK
> PINE
> MAPLE
> CHERRY
>
> 11 rows selected.
>
>
Received on Thu Oct 21 1999 - 02:41:31 CDT