Select last 3 rows from database order by id ASC?

You can use subquery. Following is the syntax −

<span class="pln">SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="pun">(</span>
<span class="pln">   SELECT </span><span class="pun">*</span><span class="pln"> FROM yourTableName ORDER BY yourIdColumnName DESC LIMIT </span><span class="lit">3</span>
<span class="pun">) </span><span class="pln">anyAliasName</span>
<span class="pln">ORDER BY yourIdColumnName</span><span class="pun">;</span>

Let us first create a table −

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> create table </span><span class="typ">DemoTable</span>
<span class="pun">(</span>
<span class="typ">   ClientId</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> NOT NULL AUTO_INCREMENT PRIMARY KEY</span><span class="pun">,</span>
<span class="typ">   ClientName</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">100</span><span class="pun">)</span>
<span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">0</span><span class="pln"> rows affected </span><span class="pun">(</span><span class="lit">0.60</span><span class="pln"> sec</span><span class="pun">)</span>

Insert some records in the table using insert command −

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Larry'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.18</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Chris'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.12</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Bob'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.10</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'David'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.12</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Carol'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.10</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Robert'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.19</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Sam'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.17</span><span class="pln"> sec</span><span class="pun">)</span>

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> insert </span><span class="kwd">into</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">(</span><span class="typ">ClientName</span><span class="pun">)</span><span class="pln"> values</span><span class="pun">(</span><span class="str">'Mike'</span><span class="pun">);</span>
<span class="typ">Query</span><span class="pln"> OK</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> row affected </span><span class="pun">(</span><span class="lit">0.12</span><span class="pln"> sec</span><span class="pun">)</span>

Display all records from the table using select statement −

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> </span><span class="kwd">select</span><span class="pln"> </span><span class="pun">*</span><span class="kwd">from</span><span class="pln"> </span><span class="typ">DemoTable</span><span class="pun">;</span>

This will produce the following output −

+----------+------------+
| ClientId | ClientName |
+----------+------------+
| 1        | Larry      |
| 2        | Chris      |
| 3        | Bob        |
| 4        | David      |
| 5        | Carol      |
| 6        | Robert     |
| 7        | Sam        |
| 8        | Mike       |
+----------+------------+
8 rows in set (0.00 sec)

Following is the query to select last 3 rows from database order by id ASC −

<span class="pln">mysql</span><span class="pun">></span><span class="pln"> SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="pun">(</span>
<span class="pln">   SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="typ">DemoTable</span><span class="pln"> ORDER BY </span><span class="typ">ClientId</span><span class="pln"> DESC LIMIT </span><span class="lit">3</span>
<span class="pun">) </span><span class="pln">tbl</span>
<span class="pln">ORDER BY </span><span class="typ">ClientId</span><span class="pln"> ASC</span><span class="pun">;</span>

This will produce the following output −

+----------+------------+
| ClientId | ClientName |
+----------+------------+
| 6        | Robert     |
| 7        | Sam        |
| 8        | Mike       |
+----------+------------+
3 rows in set (0.00 sec)