Question

describe the six clauses in the syntax of an sql retrieval query. show what type of constructs can be specified in each of the six clauses

Answer 1

Answered below

Step-by-step explanation:

An SQL retrieval query is made up of up to six clauses that must be coded in a specific sequence and they consist of;

1) SELECT - This clause allows you list the columns you want.

2) FROM - This clause indicates the tables you are retrieving information from.

3) WHERE - The where clause indicates a condition.

4) GROUP BY - Let's you group your data into specific and more meaningful information.

5) HAVING - Puts a condition in your group.

6) ORDER BY - Orders your result rows in ascending or descending order.