mardi 13 septembre 2022

SELECT returns multiple answers

I have names table with columns id, name and last_name. So what i'm trying to do is select random name from it, i tried this:

SELECT name FROM names WHERE id = floor(random()*18 + 1);

But it returns no value, one, two or even three names sometimes, why is this happening and how can i fix it




Aucun commentaire:

Enregistrer un commentaire