Đang Thực Hiện

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

Kỹ năng: MySQL

Xem thêm: 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

Về Bên Thuê:
( 3 nhận xét ) Kelowna, Canada

Mã Dự Án: #1609135

Đã trao cho:

atillafulop

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

$30 USD trong 1 ngày
(5 Đánh Giá)
2.4