Posts by Frank Queiroz • 17 points
3 posts
-
1
votes1
answer270
viewsQ: Is it possible to group a range of values?
I made the following consultation: `select t.net, t.hora, t.`data`, t.`local` from domingos t join( select net, updated, count(*) from domingos where `data` = '07/05/2017' group by updated, net…
-
0
votes1
answer35
viewsQ: Select records under multiple conditions
Code help for selecting in Mysql. Conditions are: for same 'net' and 'time' records, select the first record (min id) and another record if 'AP' is different for records of the same time and…
mysqlasked Frank Queiroz 17 -
0
votes1
answer57
viewsQ: Select extreme values from a certain range in Mysql
I need to collect only the extreme values of 'id' for each given time slot. According to the data below, I need to collect the id’s 63 and 67 for the time of 00:45:22, 80 and 84 for the time of…
mysqlasked Frank Queiroz 17