Is It Possible To Display The Records This Way With A SQL-query?

My mini database has 11 records stored in a table called “Products”. The table has two columns called “P_name” and “P_price. The records are stored in the following way and order in the database:



Counter P_name P_price

1 Shoes 15

2 Coat 16

3 Cardigan 4

4 Shoes 9

5 Cardigan 7

6 Trousers 15

7 Coat 8

8 Cardigan 14

9 Shoes 2

10 Trousers 12

11 Trousers 8



My question now is whether there exists any SQL query that will select all products and then be able to display the recordset in the exact order below (P_name should not be displayed in alphabetical order, but grouped together with other in same product category and therefore displayed after each other. P_price should be in ascending order). I have managed this far: SQL = SELECT * FROM Products where ?????? ORDER BY ?????, price ASC.



Coat 8

Coat 16

Trousers 8

Trousers 12

Trousers 15

Shoes 2

Shoes 9

Shoes 15

Cardigan 4

Cardigan 7

Cardigan 14

If it's not possible to achieve this using SQL, maybe you can suggest something else?