My SQL Order two columns with different orders – mysql October 5, 2011 Pramod T P SELECT * from emp_table ORDER BY category DESC, name ASC;