<div>
<div class="content wysiwyg-content">
Given this database table:<br />
<br />
id &nbsp; &nbsp; &nbsp; &nbsp; name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mark<br />
<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John Deo &nbsp; &nbsp; &nbsp; &nbsp; 75 <br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Max Ruin &nbsp; &nbsp; &nbsp; &nbsp; 85 <br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arnold &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55 <br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Krish Star &nbsp; &nbsp; &nbsp; &nbsp;60 <br />
<br />
I'd like to find second lowest and third lowest <br />
Searching the net I found a Query string andd tried it:<br />
<br />
$SQL2 = &quot;SELECT DISTINCT(name), id FROM table ORDER BY id DESC LIMIT 2, 1 &quot;;<br />
It failed. <br />
<br />
Please, experts, could you lead me through this? Incidentally, at the end of the line its states &quot;limit 2, 1&quot;. I wonder what &quot;,1&quot; is for. Should appreciate an explanation.
</div>
</div>


Given this database table:

id         name             mark

1          John Deo         75 
2          Max Ruin         85 
3          Arnold             55 
4          Krish Star        60 

I'd like to find second lowest and third lowest 
Searching the net I found a Query string andd tried it:

$SQL2 = "SELECT DISTINCT(name), id FROM table ORDER BY id DESC LIMIT 2, 1 ";
It failed. 

Please, experts, could you lead me through this? Incidentally, at the end of the line its states "limit 2, 1". I wonder what ",1" is for. Should appreciate an explanation.

How to find second lowest, third lowest, ...nth lowest value in a MySQL column

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.