Order by in SQL

Is it possible to order a query result based on 2 columns with the first sorting ascending on column1 and the sec开发者_如何学运维ondary sort on column2 in desc?

select * from table1 orderby column1, column2

I believe this SQL statement should work, would adding desc along with the second column work or is there any better way of doing it?

---

yes

select * from table1 orderby column1 asc , column2 desc