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:
