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...

DLP stands for ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

The _______________ manager arranges components in a two-dimensional table with some number of rows and columns.

a. BorderLayout b. FlowLayout c. GridLayout d. AbsoluteLayout

Computer Science & Information Technology