title: How to SELECT FROM the intersection of multiple subquery results?
body: <p>First of all, good news: I have only 1 table.</p>
  
  <p>Now, I have 3 similar queries:</p>
  
  <pre><code>SELECT id FROM (
    SELECT * FROM my_table
    ORDER BY columnA
    DESC LIMIT 600
    ) AS aliasA
  WHERE (revenue &gt; 10000);
  
  SELECT id FROM (
    SELECT * FROM my_table
    ORDER BY columnB
    DESC LIMIT 400, 999999999999
    ) AS aliasB
  WHERE (revenue &gt; 10000);
  
  SELECT id FROM (
    SELECT * FROM my_table
    ORDER BY columnC
    DESC LIMIT 800;
    ) AS aliasC
  WHERE (revenue &gt; 10000);
  </code></pre>
  
  <p>Notice the WHERE clause are the same.</p>
  
  <p>Is there a way to combine these 3 queries so that I can search from the intersection of the 3 sub-queries (find rows that match all 3 sub-queries, and also my WHERE clause)?</p>
  
  <p>By the way, if my single queries (before combining) can be simplified, please let me know. </p>
  
  <p>Thanks!</p>