Sign in with Google
Retrieve Names and Emails of Customers Whose Name Starts with ‘A’ in SQL
Retrieve Names and Emails of Customers Whose Name Starts with ‘A’ in SQL
Query Explanation:
● SELECT Name, Email
→ Retrieves only the Name and Email columns.
● FROM Customers
→ Data is fetched from the Customers table.
● WHERE Name LIKE 'A%'
→ Filters the customers whose names start with the letter ‘A’.
→ % is a wildcard that matches any number of characters after 'A'.
SQL Query:
USE SalesInventoryDB;
SELECT Name, Email
FROM Customers
WHERE Name LIKE 'A%';
Output:
