'im creating a query that will find a record in a group which that name is "mahdi" and already it is in the table but it wont be shown in query result

select std_family,count(std_id) as [the number of each group]
from student
where std_name like 'mahdi'       --this part
group by std_family
having count(std_id) >= 5 or count(std_id) >=2;

im creating a query that will find a record in a group which that name is "mahdi" and already it is in the table but it wont be shown in query result

sqlsql-serverlinqgroup-bywhere-clause


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions