w3resource

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 Expression: Display all those employees whose first name or last name starts with the letter D.

Relational Algebra Tree:

Relational Algebra Tree: Display all those employees whose first name or last name starts with the letter D.

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Display all those employees whose first name or last name starts with the letter D - Duration

Rows:

Query visualization of Display all those employees whose first name or last name starts with the letter D - Rows

Cost:

Query visualization of Display all those employees whose first name or last name starts with the letter D - 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.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

MySQL export schema without data

mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql

Ref: https://bit.ly/3xzB9dS