Syntax: MIN([DISTINCT]|[ALL] ) : MIN « Aggregate Functions « Oracle PL / SQL

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

Syntax: MIN([DISTINCT]|[ALL] )

 
SP2-0734: unknown command beginning "Syntax: MI..." - rest of line ignored.
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> SELECT
  2     MIN(price) min_price
  3  FROM cars;
SQL>
SQL>
SQL> drop table cars;

Table dropped.

SQL>
SQL>

 

Related examples in the same category