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

Untitled

Nassiba Zainullayeva 3 questions

Take the quiz

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

Description: Quiz on Untitled, created by Nassiba Zainullayeva on 14/12/2017.
Author: Nassiba Zainullayeva
Language: English
Views: 0
Rating: No ratings yet
Rate this quiz
Rate this quiz