MySQL query to order two column, one ASC another DESC

Question

I am trying to prepare a subject wise merit list. I am using this `mysql query`: ``` SELECT * FROM results ORDER BY qid ASC, marks DESC ``` Result is: But what I need is like this (look at marks column, I need to get same `qid` rows, ordered by `marks`): Please anyone help me. Update: And this is `result.sql` file to create the table in your pc. ``` -- phpMyAdmin SQL Dump -- version 3.5.2.2 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Mar 09, 2013 at 05:40 PM -- Server version: 5.5.27 -- PHP Version: 5.4.7 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `ges_omeca` -- -- -------------------------------------------------------- -- -- Table structure for table `results` -- CREATE TABLE IF NOT EXISTS `resul…

Accepted Answer

This is exactly what you need:

```
SELECT * 
FROM results
ORDER BY SUBSTRING( qid
FROM 1 
FOR 1 ) ASC , marks DESC
```

MySQL query to order two column, one ASC another DESC

Solution

Problem