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
https://www.czetsuyatech.com/2010/05/sql-select-row-with-same-column-value.html
SELECT T.* FROM LISTDATA T
WHERE (SELECT COUNT(TX.GID) FROM LISTDATA TX WHERE TX.GID=T.GID)>1
ORDER BY T.GID
Post a Comment