In SQL_____, aggregate function can be used in the select list or the _____clause of a select statement of sub query. They cannot be used in a _____clause.

In SQL_____, aggregate function can be used in the select list or the _____clause of a select statement of sub query. They cannot be used in a _____clause. Correct Answer Group by, where

Bissoy MCQ

Related Questions

The gypsys are a tribe of strange people. They do not have any fixed home but wander about from place to place and live in tents. they were originally natives of India. But as they reached England from Egypt ,the English took them from Egyptians. this is why they came to be called gypsys. they were beloved to possess strange powers. they could tell your fortune by reading the palm of your hand. it was thought they stole little children to train them in their way of life. whenever a child got lost it was thought that it has been carried away by gypsys so they were arrested and sent for trial. but this attitude towards the Gypsy has gradually changed.The gypsies are people who ---
All legislative subject are mentioned in three lists union list, concurrent list and state list. Any subject is not mentioned in all three list, the law on that particular subject can be framed by-
General knowledge and aptitude test(Q.51-80) Match list 1 with list 2 and select the most appropriate answer. List 1(place) Barisal-Rajshahi-Sylhet. List 2 (Specially)
A correlated subquery is where the outer query depends on data from the inner query.
Who can make laws for Union Territories on any subject under the three lists Viz. union list, state list and concurrent list?
The _______clause is used to list the attributes desired in the result of a query.
The arithmetic mean of the list of numbers given below is 4. If K and m are integers and k#m, what is the median of the list ? [Given list -3, k, 2, 8, m, 3]
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 ?
Which of the following is not an SQL aggregate function?
City High School must put together a debating team consisting of four debaters.There are candidates of equal ability : X,Y and Z who are all seniors; and A,B,C and D who are all juniors..The school requires that there should be two seniors and two juniors in the team.It is also necessary that all of the debaters be able to work with one another. *Debaters Y and A cannot work together. *Debaters Z and C cannot work together. *Debaters A and B cannot work together. If debater B is selected and debater Y is rejected,the team will consist of which foursome?