Differences

This shows you the differences between two versions of the page.

--- moodle-requete-doublons [2022/03/16 10:40] – created 172.16.7.218
+++ moodle-requete-doublons [2023/09/28 12:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ======Doublons======
 <code>
-select count(*), username from mdl_user goup by trim(username) HAVING   COUNT(*) > 1
+SELECT   id,COUNT(*) AS nbr_doublon,FROM_UNIXTIME(timecreated), username,lastname,firstname,auth FROM     mdl_user GROUP BY trim(username) HAVING   COUNT(*) > 1;
 </code>