How do I get distinct values from the table along with the count of how many rows there are containi-CodePudding

Home > Software engineering > How do I get distinct values from the table along with the count of how many rows there are containi

How do I get distinct values from the table along with the count of how many rows there are containi

Time：05-01

IN SQL (and if possible how to write it in Laravel Eloquent), if there are 10 MySQL rows having value IN', 4 rows having value 'US', 7 rows having value 'FR'; I want the query result to be three rows:

IN | 10
US | 4
FR | 7

CodePudding user response：

SELECT column_name, count (*) as c FROM table_name GROUP BY column_name ORDER BY c DESC

CodePudding user response：

Model::query()->groupBy('country_name')->select('counrty_name',DB::raw('COUNT(1)'))

Page link：https//www.codepudding.com/Softwareengineering/391478.html

Prev:iOS: encrypting file transferred by Airdrop and export compliance

Next:Can not use controller name in laravel, must use namespace

Tags：

php

mysql

laravel

Links：
CodePudding