MySQL Note--group by,limit usage

Table: ID Tag Status1A02B03C14D1First,Groupby usage1. Combined count with CountSelectStatusCount(*)           from Table           Group  bystatus

Status Count (*)
0 2
1 22. Used in conjunction with Group_concatSelectStatus,group_concat (tag) as tag from Table        Group  byStatus
Status tag
0 A, B
1 c,d

ii. usage    of limit 1 Pages are page, a       select * from      table           is recorded per page Limit (page-1)*A

View Code

MySQL Note--group by,limit usage