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

It should be easy to do, by combining ...
1- Create Table ... As Select ....
2- Select ... , count(*) from ... where ... GROUP BY ...;

hth.

G Quesnel wrote:

Thanks. Actually I figured it out. Sorry for the silly question.