SQL: Display all the data of employees whose last name begins with the letter 'D'

SQL Wildcard & Special Operator : Exercise-22 with Solution

Write a query in SQL to display all the data of employees whose last name begins with an 'D'.

Sample table: emp_details

Sample Solution :

SELECT * 
 FROM emp_details
  WHERE emp_lname LIKE 'D%'; 

Output:

Query Visualization:

Duration:

Rows:

Cost:

Practice Online

Contribute your code and comments through Disqus.

Previous: Write a SQL statement to find that customer with all information who gets a grade except NULL value.
Next: SQL Aggregate Functions Exercises Home