Sql count

This article is tagged with: Sql count and mysql

sql count

/*COUNT(column_name) will return the number of rows from the column
that are not NULL*/
SELECT COUNT(column_name)
FROM table_name;
/*COUNT(*) will return the number of rows from the table*/
SELECT COUNT(*)
FROM table_name;

select count sql

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

sum of column in sql

SELECT SUM(column_name)
FROM table_name
WHERE condition;

how to find averages on sql

SELECT AVG(column_name)
FROM table_name
WHERE condition;

To count number of rows in SQL table

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';

sql count

/* COUNT() is a function that takes on the name of a clomn as an argument
and counts the number of rows where the column is not null */
SELECT COUNT(column_name)
FROM table_name;

This article is tagged with: Sql count and mysql