Code: Select all
username | time
-----------|---------------
aq | 05:55:07
aq | 05:55:09
megi | 05:55:37
megi | 05:55:40
megi | 05:55:45
Code: Select all
SET @waktu= null;
SELECT username, tanggal, module, action, pagename,
IFNULL(timediff(`waktu`,@waktu), 0) as selisih_waktu, @waktu := `waktu` as time
FROM mdl_temporer_log2 WHERE rolename = 'Student'
ORDER BY waktu;
Code: Select all
username | selisih_waktu | time
-----------|---------------|--------------
aq | 0 | 05:55:07
aq | 00:00:02 | 05:55:09
megi | 00:00:18 | 05:55:37
megi | 00:00:03 | 05:55:40
megi | 00:00:03 | 05:55:45
Code: Select all
username | selisih_waktu | time
-----------|---------------|--------------
aq | 0 | 05:55:07
aq | 00:00:02 | 05:55:09
megi | 0 | 05:55:37
megi | 00:00:03 | 05:55:40
megi | 00:00:03 | 05:55:45
