Saurabh Gupta

Author's details

Name: Saurabh Gupta
Date registered: October 9, 2014

Latest posts

  1. Recursive Query in Teradata — November 4, 2014
  2. ROLLUP Function with Example — October 10, 2014

Most commented posts

  1. Recursive Query in Teradata — 14 comments
  2. ROLLUP Function with Example — 2 comments

Author's posts listings

Nov 04

Recursive Query in Teradata

Guest Post  Author – Saurabh Gupta In this post we will go through recursive query with one example. The recursive query features enables to query hierarchical data such as an organisation chart or bill of materials ( check the raw materials used to make a product ). Using Recursive query data with in the single table can be …

Continue reading »

Oct 10

ROLLUP Function with Example

Guest Post  Author – Saurabh Gupta   In this post we will go through ROLLUP function which is one of the Extended grouping function. ROLLUP is used to aggregate data along all the levels of hierarchy within a single dimension. For example –  In time dimension data can be aggregated along different levels like day, week, month and …

Continue reading »