title: How do I select only 1 row in sybase without using rowcount
body: <p>How do I select only 1 row in sybase without using <code>rowcount</code>? I don't have the privilege to <code>set rowcount</code> in sybase. Is there a way to select only 1 row?</p>
  
  <p>For example:</p>
  
  <pre><code>select * from table where name = 'jack' 
  </code></pre>
  
  <p>This returns two rows; how do I select only one row from the result set without using <code>set rowcount</code>?</p>