Databases
StackOverflow2013
Postsdbo
POPossible to compare COUNT(*) from multiple rows on MySQL?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPossible to compare COUNT(*) from multiple rows on MySQL?
    primarykey
    data
    text
    <p>Hi I am working on a query that is using the below schema to find out how often users are doing searches by company (the app basically allowed you to do a search by company)</p> <pre><code>SEARCH_LOG ---------- date_of_search (DATETIME) company_id (INT) COMPANIES --------- id (INT) company_name (VARCHAR) (there are more columns but these are the relevant ones) </code></pre> <p>So I am running the following query:</p> <pre><code>SELECT company_name,COUNT(*) FROM companies LEFT OUTER JOIN search_log ON search_log.company_id=companies.id GROUP BY companies.id </code></pre> <p>This is great as it returns each company and the number of search performed, however I want to express these numbers as a percentage. My knee jerk reaction was to just run the following query seperately:</p> <pre><code>SELECT COUNT(*) FROM search_log </code></pre> <p>Grab that result and just do the division on the application side, however this seems really inefficient and I'd like to do it all in one query if possible (preferably without the use of a subquery) but have no idea how to get that information.</p> <p>Any help or guidance would be appreciated.</p> <p><strong>EDIT:</strong> Maybe I wasn't totally clear about what I'm after. Instead of getting results like:</p> <pre><code>COMPANY_NAME | COUNT(*) ----------------------- CompanyA | 1 CompanyB | 3 </code></pre> <p>I'd rather see:</p> <pre><code>COMPANY_NAME | COUNT(*) ----------------------- CompanyA | 25% CompanyB | 75% </code></pre> <p>Obviously the formatting isn't super important as 25,25%,0.25 are all usable.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAndrew G. Johnson
    1. USAndrew G. Johnson
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. USCameron Conner
      1. VTFavorite
    1. COAs a percentage of what?
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. USpaulmorriss
    2. COPercentage of the total so if I got the following results: CompanyA,1 AND CompanyB,3 -- I'd rather see 25% and 75% instead of 1 and 3
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. USAndrew G. Johnson
    3. CO@Adriano Varoli Piazza -- Fixed it.
      singulars
      1. POPossible to compare COUNT(*) from multiple rows on MySQL?
      1. USAndrew G. Johnson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload