Match the following SQL keywords with their purposes:

I. SELECT
II. FROM
III. WHERE
IV. GROUP BY
V. ORDER BY

A. This is not a SQL keyword.
B. Specifies the sort order of the records
C. Specifies which table or tables contain the necessary fields
D. Specifies any criteria which will be applied to the records
E. Specifies which fields will be displayed


E, C, D, A, B

Computer Science & Information Technology

You might also like to view...

The overall visual look of a chart in terms of its graphic effects, coloring, and backgrounds is called its:

A) style. B) template. C) composition. D) gallery.

Computer Science & Information Technology

You can upgrade a lower edition of Windows 7 to a higher one

Indicate whether the statement is true or false

Computer Science & Information Technology

Chat rooms are a popular medium of instant communication via the Internet. Explain why users should be careful in communicating through chat rooms

What will be an ideal response?

Computer Science & Information Technology

The Quick Access Toolbar gives you one-click access to commonly executed tasks such as saving a file or undoing recent actions.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology