What Is Where Statement

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. … In brief SQL WHERE clause is used to extract only those results from a SQL statement, such as: SELECT , INSERT , UPDATE , or DELETE statement.

What is WHERE clause with example?

operatordescription<=Less than or Equal to=Equal to<>Not Equal toBETWEENIn an inclusive Range

What does WHERE mean in access?

In a SQL statement, the WHERE clause specifies criteria that field values must meet for the records that contain the values to be included in the query results.