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.

12 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

  8. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android training in chennai
    Ios training in chennai

    ReplyDelete
  9. These ways are very simple and very much useful, as a beginner level these helped me a lot thanks fore sharing these kinds of useful and knowledgeable information.
    Android App Development Company

    ReplyDelete
  10. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

    ReplyDelete