Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?
A)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%';
B)SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary

Question

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?
A)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%';
B)SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
C)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;
D)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;

Quizplus · Accepted Answer

All the other choices are valid ANSI SQL commands. However, choice D is not valid because we are selecting columns that are not included in the GROUP BY clause or in an aggregate function. When using GROUP BY, all selected columns must either be included in the GROUP BY clause or in an aggregate function.

Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following