How can I create Oracle SQL with specific Order by?

Question

This is my initial data pattern

I would to order data in Value column ascendingly but reserve its original groups like this

Answer 1

You can try the below -

SELECT part, "group", value
FROM tablename
ORDER BY "group", value;