no

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


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

Related

rdbms 7828903232626642655

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item