title: limit function doesn't display the required output in accordance with group by command or distinct command
body: <p>I believe this might be quiet one of the familiar questions asked on StackOverflow.</p>
  
  <p>The issue I am facing here is that I am unable to understand why the limit function is not giving me the desired output. From the given table.</p>
  
  <p><a href="https://i.stack.imgur.com/eXcwp.png" rel="nofollow noreferrer">Table</a></p>
  
  <p>I want to extract the second highest amount from the given table. </p>
  
  <p>The answer should display as <code>200</code></p>
  
  <p>I had applied  the given query :</p>
  
  <pre><code>select distinct amt from amount  order by 1 desc limit 2,1;
  
   select  amt from amount group by 1 order by 1 desc limit 2,1 ;
  </code></pre>
  
  <p>Could someone help me understand why the limit function is not throwing me the response as per the summarized table instead it's displaying the result as per the base table? also, a query that would give me the desired result.</p>