mysql - SQL statement Max(Count(*)) -

-

basically have review table product. attributes reviewid, reviewcustname, reviewtext, productid. wonder there ways count product reviews? here sql statement:

select productid, count(*) mostreviews, max(mostreviews) sm_review group productid;

i wonder possible write such sql statement? or there better way?

thanks in advance.

you can use following result. gets total count each product when order count in descending order , apply limit 1 returns product reviews:

select count(*) total sm_review group productid order total desc limit 1

Comments

Post a Comment

Popular posts from this blog

html - Cut text on left side inside button while centering -

-
i need have button text (f.e. "add basket") fluid in width. if button width little show "add basket" must cut "basket" only. did achieve of splitting <span class="text">add basket</span> into 2 parts , reverse order them in dom <span class="text">basket</span><span class="text text-prefix">add to&nbsp;</span> and show them in correct order adding .text{ float: right; } however, text inside button must centered, not work far. here fiddle, i'd appreciate ideas: https://jsfiddle.net/5cavrrhc/ under circumstances, want avoid using js this. solution ok, here go: https://jsfiddle.net/6etabchg/4/ ok, co-worker , found solution works nicely. make button position: relative make wrapper display: flex; flex-wrap: wrap-reverse; justify-content: center; reverse order make both inner spans display: inline-block;flex-shrink: 0; make 1 span should remain or...
Read more

java - Last square of 8x8 grid not drawn, using two nested FOR loops -

-
i'm having trouble understanding why code isn't working. should display checkerboard grid 8x8, but last square doesn't drawn ! idea why? i searched see if had been asked before, , didn't find anything. in advance! code: /* * file:checkerboard.java * ---------------------- */ import acm.graphics.*; import acm.program.*; public class checkerboard extends graphicsprogram { int row, column, x, y; public void run() { // checkerboard (row = 0; row < 8; row++) { (column = 0; column < 8; column++) { // x, y, x width, y width add(new grect(x, y, 50, 50)); x = column * 50; y = row * 50; } } } } btw: book i'm reading asks use 2 nested loops ( "the art , science of java" , chapter 4, exercise 11, cs-106a) you need set x , y before drawing rectangle. otherwise, last rectangle not going display: for (row = 0; row <...
Read more

What design pattern is this code in Javascript? -

-
this question has answer here: why write “.call(this)” @ end of javascript anonymous function? [duplicate] 4 answers what kind of design pattern , significance of using closure? (function(){ // code here }).call(this); edit then difference between above code , following this keyword still refer same object in both ways. (function(){ // code here })(); thats invoked function expression. more info here: http://benalman.com/news/2010/11/immediately-invoked-function-expression/ the purpose run code while protecting scope (so variables declared within don't leak out global scope. update call sets value of this function being applied on. without it, value set window object, there set outer scope.
Read more