Which of the following SQL statements will generate an error?

SELECT last_name Name FROM employees ORDER BY Name

SELECT last_name Name FROM employees WHERE Name like ‘K%’

SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY dep

SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num>5

Quiz

Sem título

Nassiba Zainullayeva 3 perguntas

Fazer o quiz

1You can not order the results of a set operation
1. AVerdadeiro
2. BFalso
2Which symbol is used to create a substitution variable?
1. A&
2. B_
3. C%
4. D*
3Which of the following SQL statements will generate an error?
1. ASELECT last_name Name FROM employees WHERE Name like ‘K%’
2. BSELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY dep
3. CSELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num>5
4. DSELECT last_name Name FROM employees ORDER BY Name

Descrição: Quiz sobre Sem título, criado por Nassiba Zainullayeva em 14-12-2017.
Autor: Nassiba Zainullayeva
Idioma: English
Visualizações: 0
Avaliação: Ainda sem avaliações
Avalie este quiz
Avalie este quiz