Multiple Choice
Based on the code above,find how many items are in category TOY.
A) SELECT SUM(*) FROM Item WHERE Category='TOY' ;
B) SELECT COUNT(*) FROM Item WHERE Category='TOY' ;
C) SELECT COUNT FROM Item WHERE Category='TOY' ;
D) SELECT COUNT* FROM Item WHERE Category='TOY' ;
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q40: A WHERE and a HAVING clause cannot
Q53: You use the SQL _ command to
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
Q65: The _ clause can be used to
Q67: Based on the code above,list the number
Q68: When used after the word SELECT,the _
Q69: When you use a name containing a
Q70: The _ data type stores integers,but uses