title: How do we get maximum value from table without using Max,Min or Order by Clause in SQL Server 2005?
body: <p>I have one table has Salary has 3 columns and I want to get maximum value from this table without using Max, Min or order by clause.</p>
  
  <p>Data </p>
  
  <p>Salary has three fields - <code>ID,Name,Amount</code>
  value of Amount - <code>100,70,80,400,300</code></p>
  
  <p>I need to get value of 400 from this data.</p>
  
  <p>I know Select max(Amount) from Salary, But i need without max,min or Order by clause.</p>
  
  <p>Thanks in advance.</p>