sql

Question

In SQL we can use aggregate function without using GROUP by
clause. (TRUE /FALSE)

Comments

yes you can use it in select clause without having a group by clause example select avg(salary) from employee employee(id,name,salary)

Answer 1

Yes it is possible .

eg : SELECT AVG(Price) AS PriceAverage FROM Products;

now see this

SELECT NAME , AVG(Price) AS PriceAverage FROM Products;

this is not possible . in that you have to place GROUP BY NAME . peace