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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1699 | batch normalize | WHRIA | 2020.02.06 | 51 |
1698 | sql replication 성공 [1] | WHRIA | 2020.02.20 | 51 |
1697 | 회귀분석 종류 | WHRIA | 2020.04.14 | 51 |
1696 | conflict of interest | WHRIA | 2020.05.03 | 51 |
1695 | android / capture and crop [5] | WHRIA | 2020.05.10 | 52 |
1694 | Visual Studio 설치후 Excel 2002 (XP) 종료시 에러 문제 | WHRIA | 2015.11.20 | 53 |
1693 | melanoma awareness [1] | WHRIA | 2019.12.27 | 53 |
1692 | nvidia docker | WHRIA | 2020.01.15 | 53 |
1691 | DDR-WRT IPTV | WHRIA | 2016.06.15 | 54 |
1690 | MedicalPhoto MSVC 2015 와 최신 boost 로... | WHRIA | 2016.08.26 | 54 |
1689 | git 특정 버젼 | WHRIA | 2020.07.11 | 54 |
1688 | lvm 확장 [1] | WHRIA | 2019.12.25 | 55 |
1687 | nvidia caffe | WHRIA | 2020.01.12 | 55 |
1686 | annotation service | WHRIA | 2020.05.03 | 55 |
1685 | 학술저널 받는법 | WHRIA | 2015.11.30 | 56 |