RE: sql help, please

From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: <eugene.pipko@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 26 Jan 2010 13:44:37 -0500

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)

Follow-Ups:
- RE: sql help, please
  - From: Eugene Pipko

References:
- sql help, please
  - From: Eugene Pipko

RE: sql help, please

Other related posts: