Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz |
Which query returns all records that start with the character ‘a’ from the name column in the employees table?
- SELECT name FROM employees WHERE name = ‘a%’;
- SELECT name FROM employees WHERE name LIKE ‘a%’;
- SELECT name FROM employees WHERE name LIKE ‘a’;
- SELECT name FROM employees WHERE name LIKE ‘%a’;