sql - Avoir au moins 10

Question

J'aimerais afficher les résultats pour les valeurs supérieures ou égales à 10.

select  name, count(*) from actor
join casting on casting.actorid = actor.id
where casting.ord = 1
group  by name
order by 2 desc

qui renverra ceci :

name    count(*)
Sean Connery    19
Harrison Ford   19
Robert De Niro  18
Sylvester Stallone  18

etc.

mais je veux renvoyer les valeurs de count(*) qui sont seulement supérieures à 10

comment faire ? avec avoir ?

Answer 1

Oui.

HAVING COUNT(*)>10

Answer 2

Essayez ceci

select  name, count(*) from actor
join casting on casting.actorid = actor.id
where casting.ord = 1
group  by name
having count(*)>10
order by 2 desc

Answer 3

Vous devez utiliser having pour cela.

select  name, count(*) from actor
join casting on casting.actorid = actor.id
where casting.ord = 1
group  by name
having count(*) > 10
order by 2 desc

Answer 4

select  name, count(*) from actor
join casting on casting.actorid = actor.id
where casting.ord = 1
group  by name having count(*) > 10
order by 2 desc