Questão 78448

• Banca: FCC
• Órgão: TRT - 18ª Região (GO)
• Ano: 2008
• Provas: FCC - 2008 - TRT - 18ª Região (GO) - Técnico Judiciário - Tecnologia da Informação
• Disciplina: Banco de Dados
• Assuntos: SQL

As cláusulas do comando de consulta da linguagem SQL devem ser escritas na seqüência

• A. SELECT, HAVING, FROM, WHERE, GROUP BY e ORDER BY.
• B. SELECT, HAVING, FROM, WHERE, ORDER BY e GROUP BY.
• C. SELECT, FROM, WHERE, ORDER BY, HAVING e GROUP BY.
• D. SELECT, FROM, WHERE, GROUP BY, HAVING e ORDER BY.
• E. SELECT, FROM, WHERE, GROUP BY, ORDER BY e HAVING.

Gabarito: D

Comentários

• SELECT     [ALL | DISTINCT | DISTINCTROW ]          [HIGH_PRIORITY]          [STRAIGHT_JOIN]          [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]          [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]     select_expr [, select_expr ...]     [FROM table_references     [WHERE where_condition]     [GROUP BY {col_name | expr | position}          [ASC | DESC], ... [WITH ROLLUP]]     [HAVING where_condition]     [ORDER BY {col_name | expr | position}          [ASC | DESC], ...]     [LIMIT {[offset,] row_count | row_count OFFSET offset}]     [PROCEDURE procedure_name(argument_list)]     [INTO OUTFILE 'file_name'            [CHARACTER SET charset_name]            export_options        | INTO DUMPFILE 'file_name'        | INTO var_name [, var_name]]     [FOR UPDATE | LOCK IN SHARE MODE]]

  fonte: http://dev.mysql.com/doc/refman/5.1/en/select.html