search of the:   for: 
code logs -> 2024 -> Fri, 19 Jan 2024< code.20240118.log - code.20240120.log >
--- Log opened Fri Jan 19 00:00:47 2024
01:56 Degi_ [Degi@Nightstar-ebpak1.pool.telefonica.de] has joined #code
01:58 Degi [Degi@Nightstar-j86j8c.pool.telefonica.de] has quit [Ping timeout: 121 seconds]
01:58 Degi_ is now known as Degi
02:05 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has joined #code
02:05 mode/#code [+qo Vornicus Vornicus] by ChanServ
02:12 JustBob [justbob@Nightstar.Customer.Dissatisfaction.Administrator] has quit [NickServ (RECOVER command used by JustLurk)]
02:12 JustBob [justbob@Nightstar.Customer.Dissatisfaction.Administrator] has joined #code
02:12 mode/#code [+o JustBob] by ChanServ
02:13 ErikMesoy1 [Bruker@Nightstar-u36.h65.232.178.IP] has joined #code
02:15 ErikMesoy [Bruker@Nightstar-u36.h65.232.178.IP] has quit [Ping timeout: 121 seconds]
04:50 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has quit [Connection closed]
04:57
< Mahal>
errr, why not SELECT machine_id, max(timestamp), user FROM scans GROUP BY machine_id;
04:57
< Mahal>
?
05:36
<@macdjord>
Mahal: Huh. That would work? To be clear, if my dataset is, say, (machine_1, 2024-01-01, alice), (machine1, 2024-01-02, bob), (machine_2, 2024-01-2, carol), then the result I want is (machine1, 2024-01-02, bob), (machine_2, 2024-01-2, carol).
05:38
<@macdjord>
My expectation for your query would be "Error: 'user' is neither part of the GROUP_BY clause nor an aggregation function"
05:40 macdjord is now known as macdjord|slep
06:08
< Mahal>
I don't know, I'm not actually an SQL person
13:02 ErikMesoy1 is now known as ErikMesoy
13:02 mode/#code [+o ErikMesoy] by ChanServ
14:59 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has joined #code
14:59 mode/#code [+qo Vornicus Vornicus] by ChanServ
17:10 macdjord|slep is now known as macdjord
17:41 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has quit [Ping timeout: 121 seconds]
--- Log closed Sat Jan 20 00:00:49 2024
code logs -> 2024 -> Fri, 19 Jan 2024< code.20240118.log - code.20240120.log >
 search of the:   for: 

[ Latest log file ]