Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
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 the employees whose first or last name begins with '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

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

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