title: SQL Query to fetch emloyee name, salary where employee name is provided
body: <p>For an <code>Employee</code> table with columns EmpId, Name and <code>Salary</code> Table with columns Id, EmpId, Salary, where EmpId of salary table is Foreign Key of Employee Table.
  Is it possible to write a SQL query so that the result contains each employee's name and the salary of all employees provided by a employee name?</p>
  <p>Sample Data</p>
  <p><code>Employee</code> Table</p>
  <pre><code>EmpId      Name       
   1         Alice      
   2         Bob        
   3         Charlie     
   4         Doug        
  </code></pre>
  <p><code>Salary</code> Table</p>
  <p>Sample Data</p>
  <pre><code> Id      EmpId       Salary 
   1         1       1000
   2         2       2000 
   3         3       3000 
   4         4       4000 
  </code></pre>
  <p>Query I tried, but could not see, how I can write employee name say, Bob, where I want to fetch employee who have higher salary than Bob. Below query gives result with salary perspective, but how to fetch by employee name?</p>
  <p>--Updated with Order By Clause, Thanks @Strawberry</p>
  <pre><code>    SELECT s.salary
      , e.empname 
      FROM
      test.employee as e, test.salary as s 
      WHERE s.empid = e.empid AND s.salary &gt; 2000 
      ORDER BY s.Salary DESC 
      LIMIT 3;
  </code></pre>