Changes between Version 13 and Version 14 of AdminTips

Timestamp:

2013-03-02T05:35:46Z (12 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -35 +35 @@
 
 Replace EVENT_ID to event id and COURSE_ID to course id.
+
 
 === Merge Students with Duplicated Accounts (the accounts starts with "s" and without) ===
@@ -80 +81 @@
 }}}
 
+
+=== Find Duplicate Students ===
+{{{
+#!sql
+select id, username, student_no  from users where student_no in (select student_no from (select student_no, count(*) c from users group by student_no having c > 1) as a) order by student_no, username;
+}}}
+
 === Merge Students old accounts into new ones ===
 The old student accounts using student number as username and the new ones uses PUID.