SELECT pid, COUNT(*) AS frequency FROM child GROUP BY pid ORDER BY frequency DESC LIMIT 1;
Last updated 22 May 2009
Statistically, the mode is the most frequently occurring value. Given tables parent(id int) and child(pid int, cid int), where child.pid references parent.id as a foreign key, what query finds the parent.id most often represented in the child id, that is, the modal count of child.pid?
SELECT pid, COUNT(*) AS frequency FROM child GROUP BY pid ORDER BY frequency DESC LIMIT 1; Last updated 22 May 2009 |
|