In our previous lesson we covered WITH ROLLUP and WITH CUBE. During that lesson you may have noticed that when we saw the summary rows, the columns had NULL as the value. Hopefully you wondered to yourself, how do I know programatically which of the rows are summary lines and which are rows that just…
Read More SQL 301 – GROUPINGYou must be aware by now I’m a Star Wars fan. So it should come as no shock, I just finished the first book of The Adventures of Lando Calrissian, The Mindharp of Sharu. This book wasn’t the greatest I’ve read, but it was enjoyable. It starts just after Lando won the Falcon, and he’s…
Read More The Adventures of Lando Calrissian #1Have you been asked to summarize some data into a nice report for management? They want to see subtotals and grand totals you say? You don’t have to drop the results of your GROUP BY statement into a temp table, and summarize the subtotals yourself. The SQL ROLLUP and CUBE commands offer a valuable tool…
Read More SQL 301 — WITH CUBE and ROLLUP