//this_for_descending_order.. SELECT * FROM TableName ORDER BY columnName DESC; // this_for_ascending_order.. SELECT * FROM TableName ORDER BY columnName ASC;