Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Structured Query Language - C993 Clauses

memorize.ai (lvl 286)

(0)

6 cards

()

Section 1

Preview this deck

ORDER BY

Front

1 / 6

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (6)

Section 1

(6 cards)

ORDER BY

Front

A SQL clause that is useful for ordering the output of a SELECT query (ASC/DESC). Optional

Back

FROM

Front

The clause that indicates the table from which to retrieve the specified columns Required

Back

SELECT

Front

The clause that specifies the columns to retrieve in the query Required

Back

GROUP BY

Front

A SQL clause used to create frequency distributions when combined with any of the aggregate functions in a SELECT statement. Optional

Back

WHERE

Front

The clause that specifies any conditions for the query Optional

Back

HAVING

Front

The clause that limits a condition to the groups that are included. Allowed only w/ GROUP BY. Optional

Back