Posted on 17th September 2024|185 views
Explain Pivot Function with example
Posted on 17th September 2024| 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
}