Using GROUP BY would tell us how many cars from each vendor we have on the lot: : COUNT « Aggregate Functions « Oracle PL / SQL






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

Using GROUP BY would tell us how many cars from each vendor we have on the lot:

   
SQL>
SQL>
SQL> CREATE TABLE cars
  2  (
  3    MAKER  VARCHAR (25),
  4    MODEL  VARCHAR (25),
  5    PRICE  NUMERIC
  6  );

Table created.

SQL>
SQL> INSERT INTO CARS VALUES('CHRYSLER','CROSSFIRE',33620);

1 row created.

SQL> INSERT INTO CARS VALUES('CHRYSLER','300M',29185);

1 row created.

SQL> INSERT INTO CARS VALUES('HONDA','CIVIC',15610);

1 row created.

SQL> INSERT INTO CARS VALUES('HONDA','ACCORD',19300);

1 row created.

SQL>
SQL> INSERT INTO CARS VALUES('FORD','MUSTANG',15610);

1 row created.

SQL> INSERT INTO CARS VALUES('FORD','LATESTnGREATEST',NULL);

1 row created.

SQL> INSERT INTO CARS VALUES('FORD','FOCUS',13005);

1 row created.

SQL>
SQL>
SQL>
SQL> SELECT
  2     Maker,
  3     COUNT(price)cars_count
  4  FROM cars
  5  GROUP BY maker;

MAKER                     CARS_COUNT
------------------------- ----------
HONDA                           2.00
FORD                            2.00
CHRYSLER                        2.00

SQL>
SQL> drop table cars;

Table dropped.

SQL>
SQL>








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.Find out which maker has a null value car with count()
4.-Using the COUNT function in Having clause
5.Example using the COUNT function with group by clause
6.Count with group by: count for a group value
7.Get the number of rows in each city group using the COUNT() function
8.count null
9.Column alias name for count function
10.Count(*) - count(column_Name)
11.count distinct column value
12.count(1)
13.count(distinct state)
14.Count(*) and column renaming
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)