Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses? a)FROM b) WHERE c)GROUP BY d)HAVING e)SELECT

Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?
a)FROM
b) WHERE
c)GROUP BY
d)HAVING
e)SELECT

Answers

kelvin
FROM specifies the table or tables to be used;
WHERE filters the rows subject to some condition;
GROUP BY forms groups of rows with the same column value;
HAVING filters the groups subject to some condition;
SELECT specifies which columns are to appear in the output;
kevowmuchiri answered the question on July 4, 2018 at 15:40

Answer Attachments

Next: What are the two major components of SQL and what function do they serve?

Previous: What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?

View more Computer Science Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions