 |
 |
Archives of the TeradataForum
Message Posted: Wed, 10 Feb 2016 @ 09:36:43 GMT
| Subj: | | Re: Split Table on Rank function |
| |
| From: | | Dieter Noeth |
Sridhar K wrote:
| | I have an requirement where I need to split the table rows into multiple parts while reading. Table has key values but they are not
sequential. So is it possible to write a query to split the rows based on rank and get corresponding Key values. | |
Have a look at QUANTILE (it's deprecated, but the manuals show how to rewrite it using RANK/COUNT), that's the easiest way to split an answer
set into n parts.
Dieter
| |
