sql where count code example
Example 1: sql query to get the number of rows in a table
SELECT COUNT(*) FROM tablename
Example 2: condition in count sql
select count(case Position when 'Manager' then 1 else null end)
from ...
select sum(case Position when 'Manager' then 1 else 0 end)
from ...
Example 3: sql count
SELECT COUNT(column_name)
FROM table_name;
SELECT COUNT(*)
FROM table_name;
Example 4: To count number of rows in SQL table
SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';
Example 5: sql count(*)
SELECT COUNT(column_name)
FROM table_name
WHERE condition;
Example 6: SQL only show where count is great than 1
SELECT COUNT( * )
FROM agents
HAVING COUNT(*)>1;