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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.