Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following
Multiple Choice
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 COUNT(EmpNo)
FROM EMPLOYEE;
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
E) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;
Correct Answer:

Verified
Correct Answer:
Verified
Q4: The SQL keyword FROM is used to
Q32: The built-in function SUM can be used
Q42: To obtain all columns,use an asterisk (*)wildcard
Q49: An alternative to combining tables by a
Q58: Columns can be sorted in descending sequence
Q63: Based on the tables below,which of the
Q67: In an SQL query,which SQL keyword is
Q69: SQL is a _.<br>A)data sublanguage<br>B)product of IBM
Q70: In an SQL query,which SQL keyword is
Q73: In an SQL query,which built-in function is