tag:blogger.com,1999:blog-35892682.post1778620845489703629..comments2023-10-19T10:59:37.092-04:00Comments on Deep Data Mining Blog: Find the most frequent items using SQL (continued)Unknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-35892682.post-92054561673062138492017-03-06T10:35:53.799-05:002017-03-06T10:35:53.799-05:00HI!
Let's assume that I would like to see the...HI!<br /><br />Let's assume that I would like to see the frequency of each fruit bought. So in the table we have information that people buy fruits. My result table would show that Apple is bought 76% of the people, Peach is bought 45% of the people. Normally, ONE person can buy several fruits, not just one.<br /><br />How can I calculate this?<br /><br />thx,<br />Imre<br /> Anonymoushttps://www.blogger.com/profile/10114600621101818502noreply@blogger.com