ÇósqlÓï¾ä£¨mysql£©

RX
Çó(ÔÚij¸ötimeÀjs_id³öÏÖ×î¶àµÄ)
±ÈÈçtimes=1026,js_id=11(±íÃûÊÇtopclick)

js_id  times
  11    1026
  12    1026
  11    1026
  11    1026
  13    1025

---

SQL code:
select js_id,count(*) as total
from topclick
where times='1026'
group by js_id
order by total desc limit 1;

---

ÒýÓÃ

SQL codeselect js_id,count(*)as totalfrom topclickwhere times='1026'groupby js_idorderby totaldesc limit1;

Äã̫˧ÁË£¬¸çÃÇ~

---

select times,js_id,count(js_id) as num from topclick group by times,js_id
´ÓÕâÀï±ßÕÒ³öÄãÏëÒªµÄËæ±ãÄĸöjs_id ×î¶àµÄ¾ÍÐÐ

---

Õý½â¡£

ÒýÓÃ

SQL codeselect js_id,count(*)as totalfrom topclickwhere times='1026'groupby js_idorderby totaldesc limit1;

---

ÒòΪ²éѯ³öÀ´ÓкܶàÏàͬµÄ"js_id,times"¼Ç¼£¬Ã¿¸öjs_id¶¼¶ÔÓ¦¶à¸öÏàͬµÄtimes¡£
ÏÂÃæд·¨ÓиüºÃµØ¿É¶ÁÐÔ£º
select js_id,count(times) as total
from topclick
where times='1026'
group by js_id
order by total desc limit 1;

---

ÒýÓÃ

ÒòΪ²éѯ³öÀ´ÓкܶàÏàͬµÄ"js_id,times"¼Ç¼£¬Ã¿¸öjs_id¶