add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE userdata (
`SlNo` INTEGER,
`UserID` INTEGER,
`points` VARCHAR(5)
);

INSERT INTO userdata
(`SlNo`, `UserID`, `points`)
VALUES
('1', '001', 'Three'),
('2', '002', 'Three'),
('3', '001', 'Thr');
SELECT `points` FROM userdata WHERE `UserID` IN (SELECT `UserID` FROM userdata GROUP BY `UserID` HAVING COUNT(*) = 1)
points
Three
SELECT `points`
FROM userdata u1 INNER JOIN (SELECT `UserID` FROM userdata GROUP BY `UserID` HAVING COUNT(*) = 1) u2 ON u1.`UserID` = u2.`UserID`
points
Three