Re: query help

Eugene wrote:
> Hi all,
> I need to show ONLY rows where columns 2 through 9 are the same.
>
> Table data:
> ------------------------------------------------------------------------------------------------------------------------------------------------------------
> CUST STYL COL HANG FOLD K_T PRICE
> STICKER BAG REBOX
> ---------- ---------- ---------- ----------
> ---------- ---------- ---------- ----------
> ---------- ----------
> 8HAS SERTEST 001S X X
> 1FA2 SERTEST 001S X X X X
> 3HA1 SERTEST 001S X X
> 8HAC SERTEST 001S X X
> 8HB3 SERTEST 001S X X
> 8HR2 SERTEST 001S X X
> ------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Thanks,
> Eugene

Use a WHERE clause.

www.psoug.org
click on Morgan's Library
click on WHERE Clause

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org