in Databases edited by
600 views
0 votes
0 votes

The answer should be D, but C is provided as the answer.

in Databases edited by
600 views

4 Comments

@Shaik Masthan

can you please provide an example where we are using aggregate function in group by clause. for rest all, i know.
0
0

 aggregate function in group by clause. 

aggregate functions can't used by groupby clause.

 

in option D, " select groupby " means

you have grouped by some attribute ===> select statement should have the attributes used by groupby clause

and along with that it may have aggregate functions.

0
0
ok. got it. thanks
0
0

Please log in or register to answer this question.