Describe the different parts of an SQL statement

Question

Sigiloso · Accepted Answer

SELECT for which columns to include in the result, (tables must be present in the FROM clause), can also include aggregates like COUNT(), SUM(), AVG()

FROM for which tables to select rows/attributes from 

WHERE which is used to filter rows based on a given criteria with comparisons (=, !=, , and keywords LIKE and BETWEEN), INNER JOIN and LEFT/RIGHT OUTER JOIN to combine data across multiple tables

ORDER BY DESC/ASC to specify ordering of a specific column name 

GROUP BY to group data based on the tables passed

HAVING to filter rows based on an aggregate used in the SELECT statement that cannot be used with  the WHERE clause

Sigiloso · Answer

I described a simple statement:

Select (Name all columns from tables or use * for all)
From (table name(s))
Where (any conditions, join statements ect)
Group By / Order By to sort or aggregate the data

Accenture

Pergunta de entrevista da empresa Accenture

Respostas da entrevista

Empresas seguidas

Buscas de vagas