Calculer pourcentage mysql

SET @total = (
SELECT COUNT(id_gest_dossier)
FROM t_users_dossiers);
SELECT id_user,
COUNT(id_gest_dossier),
ROUND(COUNT(id_gest_dossier)/@total*100,3) AS '%'
FROM t_users_dossiers
GROUP BY id_user;

Similar codes

6 votes217 views3 answers
Rename column ORACLE
SQL
5 votes193 views3 answers
Show indexes mysql
SQL
4 votes260 views1 answer
Mysql store ip address
SQL
0 vote155 views1 answer
Increment id in mysql
SQL
0 vote148 views1 answer
Mysql last 6 months
SQL
0 vote169 views1 answer
Get clob size oracle
SQL
0 vote195 views1 answer
Java spring boot connect to sql server
SQL
0 vote188 views1 answer
How to get nth number in sql
SQL
3 votes160 views2 answers
Find the median in sql
SQL
5 votes173 views3 answers
Oracle list columns in schema
SQL