CODEWITHSUNDEEP
mysql
cteera
cteera

Reputation: 67

mysql sql statement not correct in where clause

How can i fix the code for mysql maybe it wrong at m > 10

SELECT
    q_mem_tim.Hno,
    q_mem_tim.Moo,
    q_mem_tim.tambol,
    count(*) as m
FROM
    q_mem_tim
WHERE
    m > 10
GROUP BY
    q_mem_tim.Hno,
    q_mem_tim.Moo,
    q_mem_tim.tambol
order by m desc

Upvotes: 0

Views: 98

Answers (1)

Bala R
Bala R

Reputation: 108937

Try

SELECT
    q_mem_tim.Hno,
    q_mem_tim.Moo,
    q_mem_tim.tambol, count(*) as m
FROM
    q_mem_tim
GROUP BY
    q_mem_tim.Hno,
    q_mem_tim.Moo,
    q_mem_tim.tambol
HAVING
    count(*) > 10
order by m desc

Upvotes: 3

Related Questions