Posts by Jhon • 21 points
2 posts
-
0
votes2
answers3503
viewsA: Select to subtract current value from previous and return column with result
Finally I got it with the code below: select d.rank, d.DATA, d.VALOR, z.VALOR2, ABS(d.VALOR - z.VALOR2) AMPLITUDE from ( select * from ( select *, @curRank :=@curRank + 1 as rank from ( select *…
-
2
votes2
answers3503
viewsQ: Select to subtract current value from previous and return column with result
I have two tables: Samples and Values, which have columns as follows: TABLE Samples Amostra_id Data Operador_Id Carta_Id TABLE Values Amostra_Id Valor As you can see, the Values table relates to the…