sql 중복제거
2020.02.10 07:46
DELETE FROM table_a WHERE num NOT IN (SELECT * FROM (SELECT MIN(num) FROM table_a GROUP BY va) AS temp)
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
199 | lvm 축소 확장 [4] | WHRIA | 2020.01.13 | 81 |
198 | nvidia docker | WHRIA | 2020.01.15 | 52 |
197 | exif remove | WHRIA | 2020.01.28 | 48 |
196 | batch normalize | WHRIA | 2020.02.06 | 51 |
195 | airplane | WHRIA | 2020.02.10 | 199 |
» | sql 중복제거 | WHRIA | 2020.02.10 | 49 |
193 | sql replication 성공 [1] | WHRIA | 2020.02.20 | 50 |
192 | calendar javascript dropdown | WHRIA | 2020.03.01 | 41 |
191 | multiple NIC ubuntu [6] | WHRIA | 2020.03.10 | 55 |
190 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 75 |
189 | zmq async client server [1] | WHRIA | 2020.03.12 | 69 |
188 | plum | WHRIA | 2020.04.03 | 74 |
187 | kernel load | WHRIA | 2020.04.03 | 47 |
186 | chatbot | WHRIA | 2020.04.03 | 56 |
185 | fcitx | WHRIA | 2020.04.05 | 74 |