I have a query in SQL server using PIVOT function, samle query working in SQL server like -
select PT.* from (select FName, LName, RDate, Rank from Tab_Ranking)sq pivot (max(Rank) for RDate in ([2013-08-20], [2013-08-21])) as PT
What would be the equivalent query or presentation in Teradata? Please help.
For further information the date range could be for a year which are the expceted Pivot columns, so selecting seperately in the main select query is not feasible.