How to Select a Row With the Same Column Value

SELECT T.* FROM LISTDATA T
WHERE (SELECT COUNT(TX.GID) FROM LISTDATA TX WHERE TX.GID=T.GID)>1 
ORDER BY T.GID