SQL BETWEEN

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 BETWEEN - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

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

SQL BETWEEN: The BETWEEN operator is used in a WHERE clause to select a range of data between two values. The values can be numbers, text, or dates.

Syntax:
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2

<<Previous  Next>>