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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
169 | center % crop | WHRIA | 2018.12.27 | 54 |
168 | software validation [1] | WHRIA | 2020.05.10 | 53 |
167 | amp distributed pytorch [1] | WHRIA | 2020.07.14 | 52 |
166 | cloudfront | WHRIA | 2023.04.09 | 52 |
165 | boost 1.35 build | WHRIA | 2016.05.01 | 51 |
164 | rsynccp | WHRIA | 2023.02.20 | 51 |
163 | color pallate | WHRIA | 2019.04.07 | 50 |
162 | test | WHRIA | 2020.12.03 | 50 |
161 | disk error | WHRIA | 2023.02.16 | 49 |
160 | lvm 확장 [1] | WHRIA | 2019.12.25 | 48 |
159 | DDR-WRT IPTV | WHRIA | 2016.06.15 | 47 |
158 | linux raid | WHRIA | 2019.11.30 | 47 |
157 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 47 |
156 | insync | WHRIA | 2023.02.09 | 47 |
155 | youtube | WHRIA | 2016.09.30 | 46 |