How do I order by multiple columns in a SELECT query?

Question

I have a table of records like below ``` int_record_id int_category_id str_name int_order bit_active 1 1 test1 2 1 2 1 test2 1 1 3 2 test3 1 1 1 3 test4 3 1 ``` i want to select this record in a such a way that it should be sorted in the order of both `int_category_id` and `int_order` so the result should be like below ``` int_record_id int_category_id str_name int_order bit_active 2 1 test2 1 1 1 1 test1 2 1 3 2 test3 1 1 4 3 test4 3 1 ``` Does any one have an idea about its sql query, i have tried a lot i'm not getting the result correct. can any one show me the exact sql query for this.

Accepted Answer

```
select * from your_table order by int_category_id, int_order
```

How do I order by multiple columns in a SELECT query?

Solution

Problem