lets say this is an example. Lets say I have table A with 100 random numbers between 0 and 9
I will provide how many items I want, lets say 10 (this number I need to be able to change). I need then to read last 10 entries in that table A and find out number of occurrences of each of those digits.
then based on the number of occupancies I like to display the highest choices based on the following criteria:
1. If we have two digits tied for the top pick, use only those digits, plus the second best digit (with ties) in our combinations.
2. If there are three or more digits tied for the highest frequency, use only those digits for that position.
3. If we have two or more digits tied for the second highest frequency in a position, use the highest and the second highest digit with ties.
4. If we have any ties with the third highest frequency digit use only the top and second picks.
I did play with mysql while back and I know a lot of those frequencies can be handled inside mysql, I prefer to use mysql for it rather than getting items from DB to php and then processing it as speed might be a factor. I think mysql can handle large quantities of numbers much better than php would. But I need php so I can integrate it into my website.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":331073},"skills":["MySQL Administration","MySQL Programming"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-05-20T05:30:53+05:30","url":"https://www.toogit.com/freelance-jobs/MzMxMDcz"}
Remote Web Development Job In IT And Programming
Find more Web Development remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$23.95
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
We are looking for a freelancer to manage, maintain and monitor Linux server. The software resides inside the server is a fleet management software, it is developed in JAVA and MySQL. So the candidate with knowledge in JAVA will be an add on.
Du...read more
Hello,
We have an online shop that uses the salesrule table to store salesrules (discounts). A salesrule can be applied automatically or with a coupon code (salesrule_coupon). It can be assigned to one or more websites (core_website, relation ta...read more
We use a homemade CRM build upon the MVC framework Codeigniter v3. Technologies
involved are Php 7, MySQL, javascript, HTML and CSS. We added an HMVC add-on to
structure the code in modules. Currently our application has more than 200 modules...read more
Looking to build advanced queries for influxDB in Grafana.
Queries:
- Cumulative Product
- Max DrawDown
- Sharpe / Sortino / Beta
The goal is to have the metrics update based on the time range in grafana.
We are looking Microsoft SQL Server Database administrator (DBA) , Our Data Base hosted on RDS Amazon and we want to improve speed and other optimization we want highly skilled DBA at least more than 5-year experience. Have a good skype and intern...read more