Databases Querying Relational Databases Set Operations Set Operations

Zach Shlenker
Zach Shlenker
1,526 Points

I need to exclude SQL query results that start with the letters L-Z.

What is the most efficient way to accomplish this without excluding each letter 1 by 1?

2 Answers

Hi Zach!

I tried several ways to do this, such as using:

WHERE Name BETWEEN 'A' AND 'K';

And this is the only way I could get it to pass:

SELECT Name
FROM Fruit
WHERE Name < 'L'
UNION
SELECT Name
FROM Vegetable
WHERE Name < 'L';

I hope that helps.

Stay safe and happy coding!