lundi 25 juillet 2016

Using a named count() function in sql where section

Is it possible to us a named count function (I.E

SELECT n.name, **count(c.name) as freq** FROM names as n, names as c 
WHERE freq < 1 AND gender = 'f' order by rand() ) 

in the where column of a query, or would i have to do this another way?

Aucun commentaire:

Enregistrer un commentaire