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

Ohne Titel

Nassiba Zainullayeva 3 Fragen

Quiz starten

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

Beschreibung: Quiz am Ohne Titel, erstellt von Nassiba Zainullayeva am 14/12/2017.
Autor: Nassiba Zainullayeva
Sprache: English
Aufrufe: 0
Bewertung: Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz