how to get counts as a byproduct of a query

[Frank Luo <jl...@merkleinc.com>]

Very often I need to run a query against a table(s), then collect some counts. I am wondering if there is a way to kill two birds by scanning the table once. (I don’t mind to save the counts as a separate file or something like that)

For example, I got a table A and B. I need to do an inner join to get some result. In the meaning time, I need to know the table counts for both A and B. Is there a smart way to get join result as well as the counts by reading the tables once?

Thanks in advance.

This email and any attachments transmitted with it are intended for use by the intended recipient(s) only. If you have received this email in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author’s prior permission. We take precautions to minimize the risk of transmitting software viruses, but we advise you to perform your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. The information contained in this communication may be confidential and may be subject to the attorney-client privilege.