title: SQL query to find out third highest salary involving multiple tables
body: <p>I have two tables..</p>
  
  <p>Persons:</p>
  
  <pre><code>empid(primary key)
  firstname
  lastname
  email
  </code></pre>
  
  <p>Details:</p>
  
  <pre><code>Did(primary key)
  salary
  designation
  empid
  </code></pre>
  
  <p>Now I want to select <code>firstname</code>, <code>lastname</code>, <code>salary</code> of the employee with the 3rd highest salary. </p>
  
  <p>Also it would be great if you can suggest me a site where I can find SQL query exercises with solutions (I do not need an online interpreter, I have SQL Server 2008 to practice on ), I have completed w3schools (which was awesome) but I need exercises now, I tried sql.ex.ru but it was not that helpful. </p>