The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 votes

Which of the following statements about SQL queries is true?

  1. The GROUP BY clause has nothing to do with Aggregate functions.
  2. The GROUP BY clause can only be used when Aggregate functions are used.
  3. Aggregate functions can only be used when the GROUP BY clause has been used.
  4. The GROUP BY clause can be used even when Aggregate functions are not used.
in Databases by Junior (643 points) | 54 views
IV is True.

Either Group by is used with Aggregate Function OR Attribute in Group By must appear in SELECT Statement.

1 Answer

0 votes

with group by clause , we can use an aggregate function as well as column also on which we have performed grouping  as select statement
by (41 points)

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,309 questions
55,747 answers
90,534 users