SQL, 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
SQL, select a row with the same column value SQL, select a row with the same column value Reviewed by Edward Legaspi on Friday, May 21, 2010 Rating: 5

No comments:

Powered by Blogger.