Grouping

Grouping creates relations among information objects and splits the overall information set into discreet sub-groups

→ author: Francis Hunger, published on: 2016-Dec-03

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

VERSION

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

ID

FROM

WHERE

IN

AND

IN

SELECT

FROM

WHERE

AND

AND

ORDER

BY

DESC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

SELECT

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

ASC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT