| # | Date | Forum | Type | Thread | Post |
|---|
| 3 | 14 Jun 2016 @ 10:22 PDT | Database | Topic | question about RANK and TOP | SELECT 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... |
| 2 | 14 Jun 2016 @ 10:22 PDT | Database | Topic | question about RANK and TOP | SELECT 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... |
| 1 | 14 Jun 2016 @ 07:01 PDT | Database | Topic | Ask 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... |
|
|