Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

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.