SQL Sorting in ASP GridView Help

SQL IS: SELECT * FROM [Table] ORDER BY COL1 DESC, COL2 DESC, COL3 ASC" The problem is COL3 is not ASC because COL1 and COL2 is overriding it, i need COL3 to always be ASC no matter what or sort orders are in different columns. small project, hope you understand the project