Posted By

lance on 08/05/10

Tagged

Viewed 763 times

Favorited by 1 user(s)

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT COUNT(TABLE_ID), TABLE_ID 
FROM TABLE
GROUP BY TABLE_ID
HAVING COUNT(TABLE_ID)>1
ORDER BY TABLE_ID

Comment:

You need to login to post a comment.