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: Using where clause with like operator

SQL Wildcard & Special Operator: Exercise-9 with Solution

From the following table, write a SQL query to retrieve the details of the customers whose names begins with the letter 'B'. Return customer_id, cust_name, city, grade, salesman_id.

Sample table: customer


Sample Solution :

SELECT *
FROM customer
WHERE cust_name LIKE 'B%';

Output of the Query:

customer_id	cust_name	city		grade	salesman_id
3007		Brad Davis	New York	200	5001
3001		Brad Guzan	London			5005

Relational Algebra Expression:

Relational Algebra Expression: Using where clause with like operator.

Relational Algebra Tree:

Relational Algebra Tree: Using where clause with like operator.

Explanation :

Syntax of using where clause with like operator

Pictorial presentation :

Result of using where clause with like operator

Query Visualization:

Practice Online


Duration:

Query visualization of Using where clause with like operator - Duration

Rows:

Query visualization of Using where clause with like operator - Rows

Cost:

Query visualization of Using where clause with like operator - Cost

Contribute your code and comments through Disqus.

Previous: From the following table, write a SQL query to find the details of all salespeople except whose name starts with any letter within 'A' and 'L' (not inclusive). Return salesman_id, name, city, commission.
Next: From the following table, write a SQL query to find the details of the customers whose names end with the letter 'n'. Return customer_id, cust_name, city, grade, salesman_id.

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