title: Select the result of a comparison in SQL statement
body: <p>How would I achieve the following:</p>
  
  <pre><code>select (1 &lt; 2) as One, (1 &gt; 2) as Two
  </code></pre>
  
  <p>so that it would yield the following results:</p>
  
  <pre><code>One     Two
  -----------------
  True    False
  </code></pre>
  
  <p>I'm using SQL Server but a cross DBMS example would be good.</p>