title: SQL Query : Fetch Entire Row with Minimum value in the table
body: <p>What will be the optimized query for pulling out various columns of a row which HOLDS a minimum value for a particular column.</p>
  
  <p>For e.g Displaying Name and the salary of all the persons which holds the minimum salary in the category of Permanent Employees from the below table which has just three columns in it</p>
  
  <blockquote>
    <p>Employee (Name, EmployeeType, Salary) </p>
  </blockquote>
  
  <p>EmployeeType Can be Permanent or Temporary<br>
  I already know a solution but I think there might be a better way.<br>
  My solution is :</p>
  
  <pre><code>Select E.*  from Employee Where 
  Salary = (Select Min(Salary) From Employee Where EmployeeType='P') 
  and EmployeeType='P'
  </code></pre>