SQL SORTING and FILTERING on HR Database: Display all those employees whose first name or last name starts with the letter D

SQL SORTING and FILTERING on HR Database: Exercise-36 with Solution

36. From the following table, write a SQL query to find those employees whose first name or last name starts with the letter ‘D’. Return first name, last name.

Sample table : employees

Sample Solution:

SELECT first_name, last_name 
	FROM employees 
		WHERE  first_name  LIKE 'D%' 
			OR last_name LIKE 'D%';

Sample Output:

 first_name | last_name
------------+-----------
 Lex        | De Haan
 David      | Austin
 Diana      | Lorentz
 Daniel     | Faviet
 Den        | Raphaely
 Curtis     | Davies
 David      | Bernstein
 Louise     | Doran
 Danielle   | Greene
 David      | Lee
 Julia      | Dellinger
 Jennifer   | Dilly
 Donald     | OConnell
 Douglas    | Grant
(14 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following table, write a SQL query to find those job titles where the difference between minimum and maximum salaries is in the range the range 12000, 18000 (Begin and end values are included.). Return job_title, max_salary-min_salary.
Next: From the following table, write a SQL query to find details of those jobs where minimum salary exceeds 9000. Return all the fields of jobs.