A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
20200509 |
V |
SBAB028 |
17 |
1 |
20200509122515 |
|
|
|
|
127.0611 |
37.1923 |
20200509122515 |
1 |
20200509 |
V |
SBAB028 |
17 |
1 |
20200509124430 |
|
|
|
|
127.0611 |
37.1923 |
20200509124430 |
1 |
20200509 |
V |
SBAB028 |
17 |
2 |
20200509124430 |
20200509131419 |
|
|
|
127.0611 |
37.1923 |
20200509131719 |
2 |
20200509 |
V |
SBAB028 |
17 |
3 |
20200509124430 |
20200509131419 |
20200509132311 |
|
|
127.0611 |
37.1923 |
20200509132317 |
3 |
20200509 |
V |
SBAB028 |
17 |
4 |
20200509124430 |
20200509131419 |
20200509132312 |
20200509133542 |
|
127.0611 |
37.1923 |
20200509134121 |
4 |
20200509 |
V |
SBAB028 |
17 |
5 |
20200509122515 |
|
|
|
20200509124334 |
127.0611 |
37.1923 |
20200509124334 |
5 |
|
안녕하세요,
MAX(M) 인 값의 열-> 붉은색으로 표시되는 열만 추출하기 위해서
SELECT A , B , C, D, E, F, G, H , I , J , K , L, MAX(M), N
GROUP BY A , B , C, D, E, F, G, H , I , J , K , L, N
이렇게 쿼리를 작성하였는데 조회가 되지 않아서 그런데 혹시 방법이 있을까요?