Posted on 27th April 2025|185 views
Explain Pivot Function with example
Posted on 27th April 2025| views
In Teradata, pivot function is used as a relational operator for converting rows into columns. This function is mainly used for reporting. It creates customised tables.
Example
Pivot
{
SUM(salary) as salary1,
SUM(numbers) as add1
}