How to Used SQL WHERE Clause

The WHERE clause is used to extract only those records that fulfill a specified criterion.

The WHERE Format :

SELECT FIELD_NAME,FIELD_NAME
FROM TABLE_NAME
WHERE FIELD_NAME OPERATOR_VALUE;

 

The WHERE Example :

SELECT NAME, ADDRESS, JOBS, COUNTRY
FROM EMPLOYEE
WHERE COUNTRY='BADUNG';

 

Leave a Comment.