SQL_BETWEEN_operator.pdf

SQL_BETWEEN_operator.pdf - SQL BETWEEN OPERATOR The BETWEEN...

  • No School
  • AA 1
  • 3

This preview shows page 1 - 3 out of 3 pages.

Page 1 of 3 SQL BETWEEN O PERATOR The BETWEEN operator selects values within a range. The values can be numbers, text, or dates. SQL BETWEEN Syntax SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the "Products" table: ProductID ProductName SupplierID CategoryID Unit Price 1 Chais 1 1 10 boxes x 20 bags 18 2 Chang 1 1 24 - 12 oz bottles 19 3 Aniseed Syrup 1 2 12 - 550 ml bottles 10 4 Chef Anton's Cajun Seasoning 1 2 48 - 6 oz jars 22 5 Chef Anton's Gumbo Mix 1 2 36 boxes 21.35
Image of page 1

Subscribe to view the full document.