table order

#Tables include in-formation according to the sequence of data entry. Sort and filter change the original order and create new knowledge.

→ author: Francis Hunger, published on: 2016-Oct-29

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

LIMIT

SELECT

VERSION

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

LIMIT

INSERT

INTO

VALUES

ON

DUPLICATE

KEY

UPDATE

VALUES

VALUES

VALUES

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