Monday, February 8, 2010

SQL WHERE - Introduction and syntax

Explain the SQL WHERE statement. Write SQL syntax for the SQL WHERE statement along with an example.

WHERE: It is used to fetch records that fulfill a specified condition.

Syntax:
SELECT column_name(s) FROM table_name WHERE column_name operator value

Example:
SELECT balance FROM Account WHERE balance > 1000

No comments:

Post a Comment