Posts by Gomez • 47 points
3 posts
-
1
votes1
answer166
viewsQ: Split string by letter sets with numbers
I have the following string in a given array: [est] => INA1C4A1 I need to divide into sets: [0] => Array ( [mov] => IN [seq] => Array ( [0] => A1 [1] => C4 [2] => A1 ) its…
-
3
votes1
answer98
viewsQ: SQL: MAX(data) with wrong results
Good guys, have a problem, when searching for the highest date by grouping by id, I get wrong value in the Obs field. Query in use: SELECT a.n_func,a.id_sk, a.data, a.obs, b.maxdata, b.obs FROM…
-
0
votes1
answer181
viewsQ: MYSQL: Find subsequences in a sequence and group by ID
I have a table with the following result: ------------------ |seq | ID | ------------------ | 1 | 12345 | | 2 | 12345 | | 3 | 12345 | | 4 | 12345 | | 8 | 12345 | | 9 | 54321 | | 10 | 54321 | | 11 |…