Thursday, 19 February 2015

SQL for Quantile Function in Teradata

A Quantile is used to divide rows into a number of categories or grouping of roughly the same number of rows in each group. The percentile is the QUANTILE most commonly used in business. This means that the request is based on a value of 100 for the number of partitions


SELECT Product_ID1, Sales_Date1, Daily_Sales1
         ,QUANTILE(100, Daily_Sales1 ) AS "Quantile1"
  FROM   Sales_Table
  WHERE  Product_ID1 < 3000
  AND    Sales_Date1 > 1000930 ;
The calculation is percentile for every row in the Sales table on Daily sales.

9 comments:

  1. I agree with your post. Android software development kit makes the application development process lot simpler and effective. You can create best performing android application with ease. Android Training Institutes in Chennai | Android Training in Chennai

    ReplyDelete
  2. • such a good website and given to more information thanks! and more visit..
    oracle training in chennai

    ReplyDelete
  3. • Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    informatica training in chennai

    ReplyDelete


  4. such a good website and given to more information thanks! and more visit..
    java training in chennai

    ReplyDelete
  5. thanks for sharing this great content to my vision.
    oracle training in chennai

    ReplyDelete
  6. I always get satisfied reading this blog,Oracle dba training In Chennai the content in this site is always satisfying and truly helpful, I also wanted to share few links Greens Technologies Training In Chennai

    ReplyDelete
  7. Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    iOS Training in Chennai

    ReplyDelete