title: Highest/lowest value without using aggregate functions in SQL
body: <p>I have a table named <code>department</code>, which has following data</p>
  
  <pre><code>DNO DNAME   SALARY
  20  EE  30000
  10  DoC 50000
  30  ITS 20000
  </code></pre>
  
  <p>I want to select employee with maximum and minimum salary WITHOUT using <code>GROUP</code> functions or top-n analysis or <code>NOT EXISTS</code> command. Any help will be appreciated. Thanks</p>