SQL WHERE

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL WHERE - Introduction and syntax

---

<<Previous  Next>>  

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

<<Previous  Next>>