SQL ORDER BY

In SQL ORDER BY clause if we want to order the database based on 2 columns then how does the ORDER BY clause know which column is the main priority. For eg:

SELECT * FROM table WHERE some_conditions ORDER BY column_1, column_2

Then will ORDER BY clause order the records giving column_1 as the highest priority?

Thanks

[343 byte] By [acetoleveragea] at [2007-10-2 0:02:08]