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
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 1671 | zerohq encryption [5] | WHRIA | 2020.04.23 | 44 |
| 1670 | exif javascript orientation | WHRIA | 2020.04.30 | 44 |
| 1669 | melanoma awareness [1] | WHRIA | 2019.12.27 | 45 |
| 1668 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 45 |
| 1667 | mysql 암호화 [2] | WHRIA | 2020.04.24 | 45 |
| 1666 | annotation service | WHRIA | 2020.05.03 | 45 |
| 1665 | 식약청 메뉴 | WHRIA | 2020.05.14 | 45 |
| 1664 | linux raid | WHRIA | 2019.11.30 | 46 |
| 1663 | nvidia caffe | WHRIA | 2020.01.12 | 46 |
| » | sql 중복제거 | WHRIA | 2020.02.10 | 46 |
| 1661 | DDR-WRT IPTV | WHRIA | 2016.06.15 | 47 |
| 1660 | test | WHRIA | 2020.12.03 | 47 |
| 1659 | insync | WHRIA | 2023.02.09 | 47 |
| 1658 | lvm 확장 [1] | WHRIA | 2019.12.25 | 48 |
| 1657 | disk error | WHRIA | 2023.02.16 | 48 |