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

Test

Sin título

Nassiba Zainullayeva 3 preguntas

Hacer el test

1You can not order the results of a set operation
1. AVerdadero
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

Descripción: Test sobre Sin título, creado por Nassiba Zainullayeva el 14/12/2017.
Autor: Nassiba Zainullayeva
Idioma: English
Visitas: 0
Valoración: Aún sin valoraciones
Valora este test
Valora este test