title: oracle query find employee with maximum period of service
body: <p>I have these tables with the following columns :</p>
  
  <pre><code> Employee24( EMPLOYEEID, FIRSTNAME, LASTNAME,DATEOFJOINING );
  </code></pre>
  
  <p>I want to find the employee who has maximum period of service.</p>
  
  <pre><code>    Select * from employee24 where Max(DATEOFJOINING);
  </code></pre>