Order by three columns : Order By « Select Query « Oracle PL / SQL

1. Oracle PL / SQL
2. Select Query
3. Order By

Order by three columns

  

SQL>
SQL> CREATE TABLE products(
  2    product_id              NUMBER(6),
  3    name            VARCHAR2(50),
  4    subcategory        VARCHAR2(50),
  5    category           VARCHAR2(50),
  6    pack_size          VARCHAR2(30),
  7    price         NUMBER(8,2),
  8    min_price          NUMBER(8,2)
  9  );

Table created.

SQL>
SQL>
SQL> select category, subcategory, name, price
  2  from   products
  3  where  price > 100
  4  order by category, subcategory, name;

no rows selected

SQL> drop table products;

Table dropped.

   
    
  

Related examples in the same category