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, select select mysql, row select, mysql select, mysql row, mysql select columns, select mysql statement, demo aspnet page query mysql table, sql command query parent table mysql, mysql query failed table doesnt exist plesk, query mysql, mysql select table, mysql query database table remote computer, display mysql query php table easy, mysql query failed table psapersistentcache doesnt exist, mysql columns, mysql query remote table, pleskmaindbexception mysql query failed table psapersistentcache doesnt exist, php mysql query format table, mysql query php table css

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