Thanks, but I forgot to mention that I am on 9.2.0.8 Eugene Pipko Seattle Pacific Industries office: 253.872.5243 cell: 206.304.7726 P Please consider the environment before printing this e-mail From: Michael McMullen [mailto:ganstadba@xxxxxxxxxxx] Sent: Tuesday, January 26, 2010 10:45 AM To: Eugene Pipko; oracle-l@xxxxxxxxxxxxx Subject: RE: sql help, please Look up stragg on asktom.oracle.com or I believe 11GR2 has this now as an analytical ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Eugene Pipko Sent: Tuesday, January 26, 2010 1:22 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: sql help, please Hi all, I am looking for a way for show the following 'AC_892_z30' 1,2,3 'BK_281_k16' 1,2 'FN_485_a30' 1,2 in one query if possible Here is the data: -------------------------------------------------------------------------------- CREATE TABLE EP_FORM ( COL_1 VARCHAR2(30 BYTE), COL_2 NUMBER(3)