View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 07:56 AM
RK
 
Posts: n/a
Default How to get different columns total in one time query?


Hi, can someone help me, please?

I have a big table with two different fields f1 and f2, there are many
many different combinations of these two fields values.

Now I need to do this:

select f1, count(*) from table group by f1;
select f2, count(*) from table group by f2;

Each count may take long time. Can I run one query on the two fields,
and still get separate total counts of the different field-values, with
SQL*Plus only?

Thanks.

Reply With Quote