SELECT 欄位名稱
FROM 資料庫
GROUP BY 欄位名稱
HAVING (COUNT(欄位名稱) > 1)
2009年5月20日
[SQL] 查詢某欄位出現重複資料
Posted on 凌晨12:17 by 泥嗑硯
| No comments
訂閱：
張貼留言 (Atom)
Categories
工具
(2)
反思
(5)
有趣
(2)
林志炫
(1)
知識
(3)
時事
(8)
張宇
(1)
軟體
(1)
備忘
(1)
程式
(1)
詩詞
(1)
網管
(3)
影評
(2)
辨証
(3)
apache
(1)
AV
(4)
baseball
(1)
blogger
(1)
cat
(12)
CentOS
(1)
collection
(1)
cooking
(1)
DNS
(2)
feeling
(1)
firefox
(1)
flac
(1)
funny
(9)
gmail
(1)
healthy
(6)
html
(3)
icewm
(1)
ipkg
(1)
IT
(2)
javascript
(4)
Jquery
(3)
knowledge
(8)
language
(3)
linux
(29)
mail
(5)
money
(1)
mv
(3)
mysql
(2)
nas
(1)
network
(10)
networking Tools
(3)
others
(3)
P2P
(1)
pet
(10)
Photography
(1)
php
(11)
phpmyadmin
(1)
plant
(1)
reading
(1)
script
(1)
server
(1)
sexy
(1)
software
(2)
SQL
(4)
stock
(11)
store
(9)
story
(4)
Tag
(1)
teleplay
(2)
thinking
(3)
tmp
(1)
ubuntu
(30)
video
(3)
Virtualization
(8)
vnc
(1)
windows
(6)
xampp
(1)
0 意見:
張貼留言