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.

19 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
  11. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    iOS App Development Company
    iOS App Development Company

    ReplyDelete
  12. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
    Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text

    ReplyDelete
  13. it is really amazing...thanks for sharing....provide more useful information...
    Mobile app development company

    ReplyDelete
  14. 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
  15. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Mobile Marketing Service
    Mobile Marketing Companies
    Texting API
    Sms API
    sms marketing

    ReplyDelete
  16. Awesome Post!!! With unique content, I really get interest to read this post. I hope this article help many of them who looking this pretty information. Besant Technologies is a leading AWS Training . we offer this course through online we have great experience in succeeding students through online courses. we can calculate our performance through their honest comments in our sites in supporting our services. we have referral program so candidates can earn money through referral. you can share your live experience with other can generate you some money. AWS Training in Bangalore |
    DataScience Training in Bangalore |

    ReplyDelete
  17. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

    Texting API
    Text message marketing
    Digital Mobile Marketing
    Sms API
    Sms marketing

    ReplyDelete