Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following cannot be used as an argument for SUM function? ( Column1 and column2 are numeric fields of a table)

Which of the following cannot be used as an argument for SUM function? ( Column1 and column2 are numeric fields of a table) Correct Answer *

Column names or arithmetic expressions can be used as arguments for SUM( ) function, whereas *,all cannot be used. This is because the SUM( ) function calculates the sum of any specified column, not the entire records.

Related Questions

Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return
Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. Which of the following is an acceptable sequence of negotiators around the table ?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits directly across the table from O, who must sit on the other side of P?
which one of the following is not correct?
1. If one of the premises is invalid, the argument is not true
2. An argument cannot be sound if one of the premise is false
3. If premises entail the conclusion then the argument will be valid
4. A deductive argument may be valid without being sound
Two statements are given, followed by three conclusions numbered I, II and III. Assuming the statements to be true, even if they seem to be at variance with commonly known facts, decide which of the conclusions logically follow(s) from the statements. Statements: All fields are farm-houses. Some fields are gardens. Conclusions: I. Some farm-houses are fields. II. Some gardens are fields. III. Some farm-houses are gardens.
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If M sits next to P which of the following is a complete and accurate list of those who can sit next to P on P's other side ?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits next to M and S sits next to R, which of the other negotiators must sit next to s ?
Study the following pie chart and table and answer the question that follows. The number of people in a company working in various fields - Total number of people working = 2800   Percentage of females in the company working in various fields: Field Percentage IT 45% Sales 40% HR 75% Designs 60% Production 20% Services 25%   The number of females working in HR is what percentage of the total number of people working in all the fields together?