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

0 vote262 views1 answer
How to query all tables mysql at the same time
SQL
0 vote285 views1 answer
Drop index in sql
SQL
0 vote231 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote280 views1 answer
Hibernate show sql xml property
SQL
4 votes274 views5 answers
Primary key
SQL
0 vote263 views1 answer
Not between mysql
SQL
3 votes268 views1 answer
Two selects in one query
SQL
0 vote315 views1 answer
Sql basic commands
SQL
5 votes318 views1 answer
Mysql count lines
SQL
0 vote262 views1 answer
C# datetime to sql server datetime
SQL