Multiple Choice
Based on the code above,list the name of every student whose postal code is 10113.
A) SELECT FirstName, LastName WHERE PostalCode='10113' ;
B) SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' ;
C) SELECT FirstName, LastName FROM Student WHERE PostalCode='10113'
D) SELECT * FROM Student WHERE PostalCode='10113' ;
Correct Answer:
Verified
Correct Answer:
Verified
Q40: A WHERE and a HAVING clause cannot
Q54: Based on the code above,find the name
Q55: A simple condition includes the field name,a
Q57: Based on the code above,list the number,name,and
Q58: In Access,you use the _ operator to
Q59: When rows are grouped, one line of
Q60: The two tables involved in a union
Q61: You can combine values in character fields.
Q62: In SQL,you sort data using the _
Q64: Based on the code above,list the complete