Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query help

query help

From: Eugene <epipko_at_gmail.com>
Date: 10 Apr 2007 15:12:30 -0700
Message-ID: <1176243150.221368.285660@n76g2000hsh.googlegroups.com>


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 Received on Tue Apr 10 2007 - 17:12:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US