En cours

mysql query

Currently I have a MYSQL STATEMENT

"select sym, t, v from Table LIMIT 10"

result:

ABCD, 2513, 26673205

ABCD, 2505, 25627630

ABCD, 2494, 25509730

ABCD, 2486, 25402482

ABCD, 2483, 25394382

ABCD, 2480, 25389409

ABCD, 2472, 25364966

ABCD, 2466, 25331466

ABCD, 2456, 25295970

ABCD, 2452, 25287239

I need 3 extra columns in my result: num, tdiff, and vdiff

num should be the row #

tdiff is the 't' difference between row1 and row2, row2 and row3 etc

num, sym, t, v, tdiff, vdiff

1, ABCD, 2513, 26673205, 8, 1045575

2, ABCD, 2505, 25627630, 9, 117900

3, ABCD, 2494, 25509730, 8, 107248

4, ABCD, 2486, 25402482, 3, 8100

5, ABCD, 2483, 25394382, 3, 4973

6, ABCD, 2480, 25389409, 8, 24443

7, ABCD, 2472, 25364966, 6, 33500

8, ABCD, 2466, 25331466, 10, 35496

9, ABCD, 2456, 25295970, 4, 8731

10, ABCD, 2452, 25287239, 0, 0

Compétences : MySQL

Voir plus : query table, mysql query, mysql select statement, mysql statement, row select, mysql select, mysql row, mysql select columns, select mysql statement, query mysql, mysql select table, mysql columns, mysql query remote table

Concernant l'employeur :
( 3 commentaires ) Kelowna, Canada

N° du projet : #1609135

Décerné à :

atillafulop

Hi, I'm interested taking this job, this is really a quick job. Talk to you soon. Best regards, Aty

30 $ USD en 1 jour
(5 Commentaires)
2.4