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.
Simulate this if it helps you.Since you come from Oracle background, you are quite familiar with emp table.
Next level you can tweak as per your requirement. Hope it helps you.