Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Pattern Matching with LIKE

Find the names of customers whose name starts with the letter 'A' and who live in 'Pune'. Order the result alphabetically.

Table schema

Customers(id INT PRIMARY KEY, name VARCHAR(50), city VARCHAR(50))

Sample data

id | name  | city
1  | Aman  | Pune
2  | Anita | Mumbai
3  | Rahul | Delhi
4  | Alok  | Pune

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.