#DateForumTypeThreadPost
209 Apr 2016 @ 10:00 PDTToolsTopicUsing Rank Numbers are getting Skipped in Teradata 13.10 Select Region,Store,Sales, Rank()over(partition by Region Order by sales desc) as SalesRank from SalesTable Qualify SalesRank>=4 Input Region Store Sales SalesRank 2 821 82224 1 ...
129 Jun 2015 @ 05:13 PDTToolsTopicCompare current row with previous NOT NULL row in Teradata.Hi,   I need to implement a logic in which i need to compare my current row with previous NOT NULL row. I am using PRECEDING function but didn't get the desired results. Please fin...