擅长:python、mysql、java
<p>此查询从主题<code>wtf</code>获取前2个结果,并从主题<code>nowplaying</code>获取前3个结果:</p>
<pre><code>(SELECT * FROM member WHERE topic = 'wtf' ORDER BY count DESC LIMIT 3) UNION (SELECT * FROM member WHERE topic = 'nowplaying' ORDER BY count DESC LIMIT 3)
</code></pre>
<p>这是<a href="http://sqlfiddle.com/#!2/c5da82/6" rel="nofollow">fiddle link</a>。你知道吗</p>