In reference to my [previous question](https://stackoverflow.com/q/28061227/3898076).

I appended M\_id in my order by clause to make it unique ordering.

I have created a sqlfiddle : <http://sqlfiddle.com/#!2/8f2340/3>

Now I am facing issue with `DESC` ordering.

Below queries giving expected results.

```
SELECT `M_ID`, `CON_FRST_NM` FROM `sample_table` order by `CON_FRST_NM` LIMIT 0,60

SELECT `M_ID`, `CON_FRST_NM` FROM `sample_table` order by `CON_FRST_NM`,`M_ID` LIMIT 0,60

SELECT `M_ID`, `CON_FRST_NM` FROM `sample_table` order by `CON_FRST_NM`,`M_ID` ASC LIMIT 0,60

SELECT `M_ID`, `CON_FRST_NM` FROM `sample_table` order by `CON_FRST_NM` DESC LIMIT 0,60

```

Below query is not giving expected result.

```
SELECT `M_ID`, `CON_FRST_NM` FROM `sample_table` order by `CON_FRST_NM`,`M_ID` DESC LIMIT 0,60

```

Please help me out.

Thanks.