asd

Question	Answer
What is the logical query processing order of the followings clauses: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY	1. FROM 2. WHERE 3. GROUP BY 4. HAVING 5. SELECT 6. ORDER BY
What is a relation? Define the term!	A relation in the relational model is what SQL represents with a table. A relation has a heading and a body. The heading is a set of attributes (what SQL attempts to represent with columns), each of a given type. An attribute is identified by name and type name. The body is a set of tuples (what SQL attempts to represent with rows). Each tuple’s heading is the heading of the relation. Each value of each tuple’s attribute is of its respective type.

Resource summary

	Created by João Vitor de Oliveira Carlos over 5 years ago