Count() with where clause : COUNT « Aggregate Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Aggregate Functions
  3. COUNT

Count() with where clause

  

SQL> CREATE TABLE customers
  2  (
  3     id                NUMBER,
  4     state_province    VARCHAR2(40),
  5     country_id             CHAR(2)        CONSTRAINT           customer_country_id_nn NOT NULL,
  6     phone_number VARCHAR2(25),
  7     income_level      VARCHAR2(30),
  8     credit_limit      NUMBER,
  9     email             VARCHAR2(30)
 10  );

Table created.

SQL>
SQL>
SQL> select count(*)
  2  from   customers
  3  where  state_province = 'Delhi';



  COUNT(*)
----------
         0

1 row selected.

SQL>
SQL> delete from customers
  2  where state_province = 'Delhi';

0 rows deleted.

SQL>
SQL> drop table customers;

Table dropped.








Related examples in the same category

1.COUNT(column) and COUNT(*): count the number of rows passed into the function.
2.Syntax: COUNT([DISTINCT]|[ALL] )
3.Using GROUP BY would tell us how many cars from each vendor we have on the lot:
4.Find out which maker has a null value car with count()
5.-Using the COUNT function in Having clause
6.Example using the COUNT function with group by clause
7.Count with group by: count for a group value
8.Get the number of rows in each city group using the COUNT() function
9.count null
10.Column alias name for count function
11.Count(*) - count(column_Name)
12.count distinct column value
13.count(1)
14.count(distinct state)
15.Count(*) and column renaming
16.Count date field value, and calculation
17.Count department and calculate average salary
18.Count employee in a department after grouping by department id
19.Count employee, group by department id and job title
20.count(*) - count(onhand)
21.count(*) vs count(column name)