Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: All
Apr 28, 1999

Create Summary Tables Efficiently

Suppose you have a table that contains transactions for different products and clients. Each day you need to summarize this information. If you need to know the sales figures for each product, irrespective of the clients, the sales figures for each client regardless of product, and the normal grouping of product by client, it seems you need at least three separate queries and consequently three passes through your data. However, if you use the "with cube" keyword, you can obtain all the information with one pass through your data.
 
select client ,product,sum(amount) as 'Sum'
from trans
group by client, product
with cube
This will provide you with all the answers in one query.
Joseph Lax
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date