RANK ():- As the function name implies, RANK returns ranking (ordered) of rows based on the number or expression given in the ORDER BY clause. Note that we do not need to give anything inside the RANK function. Just give it to the ORDER BY clause and things would be taken care. Let’s work out [...]

Popularity: 31% [?]

SUM ():- When used with partition clause, SUM () function returns the cumulative or moving sum of an expression based on how the aggregation group is specified. This function can also be used in place of CSUM and MSUM which are Teradata-specific functions and are discouraged to a great extent. As per recent recommendations from [...]

Popularity: 38% [?]

COUNT ():- As you know when you use this function as aggregate function, it would just return the total number of rows present in the SELECT statement. But the same function when used with OLAP, returns the cumulative or moving count for an expression, let’s see how this is done. Let’s also use the same [...]

Popularity: 26% [?]

Let’s work out some examples of OLAP functions that are being discussed in the previous articles. Before that make sure you have a table and there is data present init. Follow the below instruction to create a temporary table and insert data into it. While inserting data you might encounter one of the following errors:
3520:  [...]

Popularity: 27% [?]

1. One of the useful features in Ordered Analytical Computation is to produce/define data sets or data subsets dynamically. This is done by the usage of the OVER () phrase (detail later). This OVER () feature can be used with all the aggregate functions too.
2. Introducing the usage of QUALIFY Clause: If there is a [...]

Popularity: 20% [?]

OLAP or On Line Analytical Processing functions are knows as “Ordered” analytical functions in Teradata environment.  These functions provides support for many decision support  operations in data mining environments that require an ordered set of results set or depend on values from a previous row. These functions are categorized as follows:
• Window aggregate functions
• Rank [...]

Popularity: 34% [?]

There are some special keywords introduced here which are only used in case of a stored procedure. Let’s see which all keywords are used for what purpose.
There are 3 types of the parameter being specified.
IN                – used for input type parameter only.
OUT              – used for output type parameter only.
INOUT           – INOUT can be both input [...]

Popularity: 24% [?]

If there is anything lacking in SQL to make it a complete programming language, Stored Procedures fulfills the same. Stored Procedures are written in SQL and consist of a set of control and condition handling statements. These features provide a server-based procedural interface to the Teradata Database for application programmers. What does this mean? It [...]

Popularity: 50% [?]

As you might know a View in SQL is nothing but a SELECT statement, sometimes more than one too, that is stored in the Data Dictionary and is executed when you want to use it. It does not have any physical memory for data; the data that you see in a View comes from tables [...]

Popularity: 38% [?]

One thing to note here is that the when you set the output limit, the query still goes thru all data, only the output is reduced to the number specified by you. Here is the way to do it.
1)     Click on Tools.
2)     Click on Options.
3)     Click on the ‘Answer Set’ tab.
4)     Off to the right [...]

Popularity: 14% [?]