Home » SQL Basics » Retrieving Data » Using Where

Using Where

Using Where Clause:

Syntax: SELECT “column_name1”, “column_name2″,….”column_nameZ” FROM “table_name”
WHERE “condition”

Example: SELECT name, age FROM employee where age > 35

In the above example it only displays all employees whose age is greater than 35.

Leave a Reply

Your email address will not be published. Required fields are marked *