
November 14th, 2013, 05:39 AM
|
Registered User
|
|
Join Date: Nov 2013
Posts: 4
Time spent in forums: 2 h 19 m 9 sec
Reputation Power: 0
|
|
Logic problem in query
Hi I am new to mysql database So can one help to my problem to resolve. I hava table "eventdata" like below
deviceID accountID timestamp speedKPH address
--------- -------- ---------- ---------- ----------------- -------------
preva1 bolero 1359088786 8.4729 Ullalu Road
preva1 bolero 1359088796 0 Ullalu Road
preva2 bolero 1359088886 0 nice Road
preva3 bolero 1359088886 8.47 Ullalu Road
preva1 bolero 1359088986 0 nice Road
preva3 bolero 1359088986 8.4729 Ullalu Road
preva1 bolero 1359088996 31 Baneerugatta
preva1 bolero 1359088998 0 Kail roald
preva3 bolero 1359088786 32
preva1 bolero 1359088896 34 Bhel
preva2 bolero 1359088786 24 Ullalu Road
preva1 bolero 1359088766 0 nice Road
preva1 bolero 1359088789 0 Nayagara
Here i need output table will be like shown below
accountID deviceID timestamp1 timestamp2 Diffstp
preva1 bolero 1359088766 1359088789 23
preva1 bolero 1359088789 1359088796 7
preva1 bolero 1359088796 1359088987 191
preva1 bolero 1359088987 1359088998 11
preva1 bolero 1359088998
can any one help for me to do this
|