Skip to main content

How to get a frequency distribution table in MySQL

Sometimes when we are searching for something, we tend to look too deep and with wrong keywords. Forget about SQL procedures, the REPEAT() function and setting variables. If you want a result set with two columns, one the ID, and the other a frequency count, then use this:

SELECT id, COUNT( someValue ) AS frequency FROM tableName GROUP BY someValue;

Your welcome!

Labels:

Comments

walwynkackley said…
Hard Rock Hotel & Casino Dr. Mountain View, Nevada, USA
With over 대전광역 출장샵 23000 guestrooms and suites, 의정부 출장샵 the 춘천 출장마사지 Hard Rock Hotel & 당진 출장마사지 Casino in Mountain View is home to more than 2600 electronic games, a popular music venue, 과천 출장샵
March 4, 2022 at 10:53 PM
Post a Comment

Popular posts from this blog

A Short Online Letter to the Board of Alphabet Inc.

Dear Chairman Hennessy, I would like to openly share a question that kept coming back to me in the past couple of days, and that gave me courage to write a short open letter for the first time in my life. While catching up with daily news I came across a couple of articles in the past week alone, namely on the world’s remaining wilderness areas that are under threat . That the Earth’s oceans have retained 60 percent more heat each year than we’ve previously thought, that humanity has wiped out 60% of animal populations since 1970, that China has legalised rhino horn and tiger bone usage after 25 years, to calling for urgent action to develop technologies for negative emissions because our clean energy efforts won’t be enough. Here’s the question: is there actually a future for us, for your company, for humanity and our natural environment? What we do today will lay down the trajectory for our carrying capacity on Earth. Instead of investing in self-driving transportation and
Post a Comment
Read more

But Google what about mobile phones that do not support Javascript?

In the global device market, there are still between 0.2% and 5.4% of phones that do not support Javascript, at least in these set of countries according to this site. In case your mobile website falls within this set than what do you do when you want to optimize CSS delivery by deferring the loading of some CSS but still serving the complete CSS to non-Javascript websites?
33 comments
Read more

A useful shortcut in PHP 5

Recently I started using a shortcut for my $_GET variables in PHP 5. It seems that instead of doing the following: <?php     $page = $_GET['page'];     $article = $_GET['article']; ?> There is an easier way where all the $_GET variables can be assigned automatically.
2 comments
Read more