Count(*) and column renaming : COUNT « Aggregate Functions « Oracle PL / SQL






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

Count(*) and column renaming

  

SQL>
SQL>
SQL> create table product(
  2          product_id          integer     primary key
  3          ,price                  number(7,2)
  4          ,description            varchar2(75)
  5          ,onhand                 number(5,0)
  6          ,reorder                number(5,0)
  7          ,supplier_no            integer
  8  );

Table created.

SQL> -- product Table Inserts:
SQL> insert into product(product_id, price, description, onhand, reorder)values (1,2.50,'Happy Birthday',100,20);

1 row created.

SQL> insert into product(product_id, price, description, onhand, reorder)values (2,23.00,'Happy Birthday',null,null);

1 row created.

SQL> insert into product(product_id, price, description, onhand, reorder)values (3,null,'Happy New Year',null,null);

1 row created.

SQL> insert into product(product_id, price, description, onhand, reorder)values (4,1.50,'Happy New Year',50,10);

1 row created.

SQL>
SQL> select count(*) "No. of Products" from product;

No. of Products
---------------
              4

1 row selected.

SQL>
SQL>
SQL> drop table product;

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() with where clause
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)