Am trying to use DISTINCT clause to get all ages for users named john, but dont know why am getting single resluts | TABLE USERS | +--------+-------------------+ | ID | NAMES | AGE | +--------+----------|--------+ | 1 | John | 35 | | 2 | Mike | 31 | | 3 | John | 56 | +--------+-------------------+ my $get_age = $DBH->prepare("SELECT DISTINCT AGE FROM USERS WHERE NAMES = ?"); $get_age->execute('John'); $age = $get_age->fetchrow(); Am only getting Age 35 for john, but i want to get all ages for users named john