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

Home -> Community -> Usenet -> c.d.o.misc -> Need Advice

Need Advice

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 13 Sep 2006 03:47:35 -0700
Message-ID: <1158144455.681850.32370@m73g2000cwd.googlegroups.com>


Greetings,

           I have a table as:
test_table

col1	col2	col3	col4	col5
1	0	0	1	1
0	0	1	0	0
1	1	0	0	1

.................................
.................................
.................................

There is some application which is dng some processing and giving the output
in this table in the form of 1's and 0's. The objective is to count the record for each combination and put them in a separate table, final_table, with the count value.

For eg:

For the first combination (1 0 0 1 1), if there are 100 such repetitions in test_table
, so my final table will have

col1	col2	col3	col4	col5	count
1	0	0	1	1	100

and so on for different combinations.

Can anyone show me the right direction to achieve the same?

TIA DB version Info:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production Received on Wed Sep 13 2006 - 05:47:35 CDT

Original text of this message

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