Node is saved as draft in My Content >> Draft
-
Use of Group By and Having Statement
Group By Statement:
In MYSQL, Group By Statement helps you to group the Result with one column or more column. Group By is mostly used with some functions.
Having Statement:
In Having Statement, it provides restriction in record's result Obtained by Group By Statement.
For example,
SELECT APARTY.FNAME,COUNT(FNAME) AS NumberOfRecord from APARTY GROUP BY FNAME HAVING COUNT(FNAME) > 1;
Output :
SNO |
FNAME |
NumberOfRecord |
1 |
Nidhi |
3 |
2 |
Akshay |
6 |
3 |
Mahendra |
4 |
4 |
Ankit |
2 |
0 Comment(s)