mysql get count of rows

SELECT COUNT(*) FROM my_table;
SELECT COUNT(*) FROM my_table WHERE my_column IS NULL;
SELECT COUNT(*) FROM my_table WHERE my_column = 'my_value';
SELECT COUNT(DISTINCT tel) gender_count,
       COUNT(DISTINCT CASE WHEN gender = 'male'   THEN tel END) male_count,
       COUNT(DISTINCT CASE WHEN gender = 'female' THEN tel END) female_count
FROM people;

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

count the number of rows in mysql count no of rows in mysql mysql where count row mysql count row in where all count row mysql mysql database get row count of all tables count and display the number of rows in a mysql database table mysql get count rows and count conidiotn count data each row in mysql count row in table mysql mysql_query row count counting rows in mysql count value of all rows mysql mysql count every row get row count in mysql query how to find the count of data in mysql mysql count for each row how to count the number of rows returned by a query in mysql how to count how many row in mysql count in mysql number of rows mysql select count number of rows how to get count also data in mysql mysql count rows query result python mysql count rows mysql get row count of a query mysql get total row count how to get number of rows in table in mysql get number of rows in table mysql how to find the count of items in table in mysql how to get number of rows in mysql mysql how to get row count mysql count of row for each id mysql count all the number of rows in the table get count of rows in mysql mysql check row count my sql row count of a table mysql get number of rows from query count rows from mysql query mysql count selected rows count rows mysql mysql count number of rows in result mysql result count row mysql get row count mysql get count row where id count number of entries in mysql number of rows select mysql count and rows mysql mysql count rows returned count mysql rows mysql count total rows count num rows mysql Getting MySQL row count how to get count of rows in mysql how to count rows in mysql in select how to count records in mysql SELECT COUNT records mysql how to count rows in mysql query mysql rows count mysql query to count number of rows in a table mysql get the number of rows in a table mysql count number of items in a row how to count rows in mysql hoe to get row count in mysql mysql count of rows how to count rows form a table mysql best way to count rows mysql get row count in mysql how to count the rows in mysql get count of items in mysql how to check row count of record in mysql table mysql row count by specific id mysql return row count how to get row count in mysql count no. of rows in mysql count row that have data only mysql python mysql get row count mysql how to count row select where count of rows mysql count row mysql how to get count of rows in mysql python mysql count records mysql count the number of rows returned mysql how to count rows in a table how to get the total count of rows in mysql mysql count num rows counting row in database mysql table finding the number of rows mysql mysql get number of rows row_count mysql count number of rows in mysql mysql count rows in table row count mysql mysql count row math in mysql statement count rows mysql statement count rows which mysql function is used to count the number of rows in a mysql query? how to sotre the count of something in mysql get rows count mysql row count in mysql how to get the number of rows in mysql database select rows with count 1 in mysql count records in mysql mysql row count count number of rows returned mysql count number of row return mysql mysql return rows that have a certain count number mysql count number of rows count rows on mysql get number of rows mysql count total number of rows in mysql how to count total number of records in mysql count row in mysql count rows in mysql mysql get rows count mysql count how many rows count row number in mysql mysql count all rows mysql count rows mysql get count of rows

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example