#DateForumTypeThreadPost
314 Jun 2016 @ 10:22 PDTDatabaseTopicquestion about RANK and TOPSELECT TOP 100 sku, store, amt, RANK()OVER (PARTITION BY store ORDER BY amt DESC) FROM trnsact; Not really I want The following is what I want and I only want t...
214 Jun 2016 @ 10:22 PDTDatabaseTopicquestion about RANK and TOPSELECT TOP 100 sku, store, amt, RANK()OVER (PARTITION BY store ORDER BY amt DESC) FROM trnsact; Not really I want The following is what I want and I only want t...
114 Jun 2016 @ 07:01 PDTDatabaseTopicAsk help regarding to TOP, Rank and Partition Hi, I am new to Teradatabase and try to adapt my way into it. I am a data analyst not a developer.  Say I have a database as follow Table name is TRS PK sku   store  price&n...