It is simple to Sort the records by One Column in ASC and Another Column in DSC You can just use: SQL Query Syntax: SELECT Col1,Col2,... FROM TABLE ORDER BY ASC Col1, DESC Col2; for further assistance refer this W3 Schools Website Link:See Example 2 Well it is for MYSQL But most of them should work.