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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1729 | Slovenian - slovenščina | WHRIA | 2024.05.24 | 2 |
1728 | Swedish - svenska | WHRIA | 2024.05.24 | 2 |
1727 | Thai - ไทย | WHRIA | 2024.05.24 | 2 |
1726 | Xhosa - isiXhosa | WHRIA | 2024.05.24 | 2 |
1725 | 아저씨에게 [1] | ^&^ | 2004.04.25 | 3 |
1724 | Armenian - հայերեն | WHRIA | 2024.05.24 | 3 |
1723 | Bulgarian - български | WHRIA | 2024.05.24 | 3 |
1722 | Czech - čeština | WHRIA | 2024.05.24 | 3 |
1721 | Filipino - Filipino | WHRIA | 2024.05.24 | 3 |
1720 | Danish - dansk | WHRIA | 2024.05.24 | 4 |
1719 | Kazakh - қазақ тілі | WHRIA | 2024.05.24 | 4 |
1718 | 아저씨~ [1] | ^&^ | 2004.05.15 | 5 |
1717 | Dutch - Nederlands | WHRIA | 2024.05.24 | 5 |
1716 | Corsican - Corsican | WHRIA | 2024.05.24 | 6 |
1715 | Serbian - српски | WHRIA | 2024.05.24 | 6 |