Write a query to fetch records where the name starts with ‘A’.

Task:

Fetch employee records where the name starts with the letter 'A' from the employees table.

Step 1: Use the LIKE Operator

The SQL LIKE operator is used for pattern matching in strings.

• LIKE 'A%' means:

  • Starts with A
  • Followed by zero or more characters
  • % is a wildcard for any number of characters

SQL Query

SELECT * FROM employees
WHERE name LIKE 'A%';

Sample Data in employees Table (as added earlier)

Output After Running Query

Explanation:

• Only one record matches the condition: Alice Johnson
• Because her name starts with ‘A’

Additional Tips:

1. Case-sensitivity depends on the database:

   • MySQL: Not case-sensitive by default (so a% works like A%)
   • PostgreSQL: Case-sensitive (A% ≠ a%)

2. To match case-insensitive in all databases, you can use:

   WHERE LOWER(name) LIKE 'a%'