데이터가 아래와 같이 있다면..
data 컬럼의 데이터가 0을 기준으로 순차적인 순번을 가져올 수 있을까요?
(데이터)
=====================================
_timestamp | data
=====================================
"2017-07-11 09:21:59.938" 55
"2017-07-11 09:21:31.475" 55
"2017-07-11 09:21:02.23" 23
"2017-07-11 09:20:59.954" 0
"2017-07-11 08:55:35.978" 89
"2017-07-11 08:55:01.122" 68
"2017-07-11 08:54:49.339" 57
"2017-07-11 08:54:19.887" 0
(원하는 결과)
=====================================
_timestamp | data | 순번
=====================================
"2017-07-11 09:21:59.938" 55 4
"2017-07-11 09:21:31.475" 55 3
"2017-07-11 09:21:02.23" 23 2
"2017-07-11 09:20:59.954" 0 1
"2017-07-11 08:55:35.978" 89 4
"2017-07-11 08:55:01.122" 68 3
"2017-07-11 08:54:49.339" 57 2
"2017-07-11 08:54:19.887" 0 1
|