How to make a selection in the database by key?

Question

SQL

There is a table, how to find a user for a day who has more rows in the table?

SELECT * FROM `cover_wid_comments` WHERE `id_group` = 150444045

For example, you need to find the user who has the most comments in the database for today id_group=150444045, the user id isfrom_id

Answer 1

SELECT `from_id`
  FROM `table`
  WHERE `date` >= NOW() - INTERVAL 1 DAY
    AND `id_group` = :group
  GROUP BY `from_id`
  ORDER BY COUNT(*) DESC
  LIMIT 1

Answer 2

In MySQL dialect like this

SELECT `from_id`, COUNT(`from_id`) as 'posts'
FROM `cover_wid_comments`
WHERE DATE_ADD(`date`, INTERVAL 1 DAY) > NOW() AND `id_group`=150444045 
GROUP BY `from_id`
ORDER BY count(`from_id`) DESC
LIMIT 1

this is the top user when sorting by the number of occurrences (repetitions) of the field value