How to calculate the total count of rows in a table in SQL?
Sandhya Answered question July 5, 2023
The SQL COUNT(), AVG() and SUM() Functions
- SELECT COUNT(column_name) FROM table_name. WHERE condition;
- SELECT AVG(column_name) FROM table_name. WHERE condition;
- SELECT SUM(column_name) FROM table_name.
- ExampleGet your own SQL Server. SELECT COUNT(ProductID) .
- Example. SELECT AVG(Price) .
- Example. SELECT SUM(Quantity)
Vishalini.R Answered question July 5, 2023