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

-2 votes209 views1 answer
No module named '_sqlite3
SQL
16 votes195 views2 answers
Mysql date between two dates
SQL
0 vote175 views1 answer
Materialized view redshift
SQL
4 votes191 views2 answers
Dbms_scheduler stop job
SQL
1 vote205 views1 answer
Oracle stop
SQL
0 vote190 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
1 vote183 views3 answers
Getdate function in postgresql
SQL
0 vote283 views1 answer
Shortcut run sql pgadmin
SQL
0 vote193 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote224 views1 answer
Psql generate id in existing database
SQL