title: mysql select inside limit
body: <pre><code>select
    id
  from
    tableABC
  limit (select count(id) from tableCBA), 1
  </code></pre>
  
  <p>If I need select in limit as I have shown here in sample code, how can I do this in mySql? This is only simplified code for purpose of this forum, otherwise this is a part of sophisticated case when else select.</p>