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. |