Ravindra BagaleCourses & study guides Track your progress

Aggregate Functions: SUM, COUNT आणि AVG aggregates MIN MAX — Ravi Sir's Cards

All SQL cards

Revision cards

SUM, COUNT and AVG aggregates. Managers often want one number, like total sales, the number of orders or the average order value.
SUM, COUNT and AVG aggregates · PNG

Interview cards

What is the difference between COUNT(*) and COUNT(column)? COUNT(*) counts every row. COUNT(column) counts only the rows where that column is not NULL.
What is the difference between COUNT(*) and COUNT(column)? · PNG

Comparison cards

Aggregate without GROUP BY. When you use an aggregate like SUM without GROUP BY, SQL returns one row for all the rows you kept.
Aggregate without GROUP BY · PNG