title: In sql To use ALL command instead of MAX command
body: <p>I want to Find <code>sids</code> with the highest rating with all command.</p>
  
  <p>I Find it with <code>max</code> command by writing </p>
  
  <pre><code>select S.sid,S.sname 
  from Sailors S 
  where S.rating = (select max(S1.rating) from Sailors S1)
  </code></pre>
  
  <p>But also I want to find it by using <code>all</code> command so I write it by writing</p>
  
  <pre><code>select S.sid,S.sname 
  from Sailors S 
  where  S.rating &gt; all (select S.rating from Sailors S)
  </code></pre>
  
  <p>But it Doesn't give the same result.</p>
  
  <p>What is My error? How can I regulate it?</p>