The Gateway to Computer Science Excellence
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 | 101 views
IV is True.

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

2 Answers

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
0 votes
normally GROUP BY clause is used with Aggregate function. However GROUP BY clause can be used without aggregate function also. hence the option IV is correct.
by Active

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
52,223 questions
59,811 answers
118,086 users