Multiple Choice
Even though you can select all the fields from a table,you cannot use a(n) ________ in a query in which you are using the GROUP BY clause.
A) semicolon
B) asterisk
C) dollar sign
D) ampersand
Correct Answer:

Verified
Correct Answer:
Verified
Q29: Which of the following will NOT calculate
Q30: Which of the following is NOT true
Q31: The following SELECT statement: SELECT EmpFirstName,EmpLastName<br>FROM tblEmployee<br>WHERE
Q32: An aggregate function differs from a calculated
Q33: A union query is used to query
Q35: When you edit a crosstab query in
Q36: Joins are performed based on a(n)_,which specifies
Q37: A subquery is usually added in the
Q38: Match the following terms to their definition:<br>I.SELECT<br>II.FROM<br>III.WHERE<br>IV.AS<br>V.HAVING<br>A.Includes
Q39: The INNER JOIN clause returns all rows