title: How to compare two query results for equality in MySQL?
body: <p>I'm a MySQL user. I have two queries, and I wish to <strong>compare their results for equality</strong>. I would like to do this with a single query which would return true or false, so each of my two queries would most likely take the form of sub-queries.</p>
  
  <p>I would like to avoid returning the results from both queries and comparing them at the application level, to cut down on communication and to improve performance. I would also like to avoid looping over the results at the database level if possile, but if there's no other way, so be it.</p>
  
  <p>I have searched high and low for an example on how to do this, but have come up empty handed. Some <strong>sample code</strong> would be most appreciated, because I'm a newbie to SQL programming. Thanks!</p>
  
  <p><strong>Note:</strong> I'm looking for a solution which would work with any two arbitrary queries, so I'm going to refrain from posting what my two queries happen to be.  </p>