In many cases, the Where clause is the most important part of the Select statement. Web developer can find
records that match several conditions using the And keyword, and he/she can find records that match any
one of a series of conditions using the Or keyword. Web developer can also specify greater-than and less-than
comparisons by using the greater-than (>) and less-than (<) operators. The following is an example with a different table and a more sophisticated Where statement:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

SELECT * FROM Orders WHERE ord_date < ‘2011/01/01’ AND ord_date > ‘2009/01/01’

This example uses the international date format to compare date values. Although SQL Server supports many date formats, yyyy/mm/dd is recommended to prevent ambiguity.

If Web developer is using Microsoft Access, he/she would need to use the U.S. date format, mm/dd/yyyy, and replace the apostrophes around the date with the number (#) symbol.