| # | Date | Forum | Type | Thread | Post |
|---|---|---|---|---|---|
| 2 | 09 Apr 2016 @ 10:00 PDT | Tools | Topic | Using 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 ... |
| 1 | 29 Jun 2015 @ 05:13 PDT | Tools | Topic | Compare 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... |