SQL BETWEEN - Introduction and syntax
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
SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns,
just like a real table..............
GROUP BY: It is used with aggregate functions to group the result-set by one or
more columns................
The IN operator allows you to specify multiple values in a WHERE
clause................
LIKE clause is used for pattern matching. % is used to match any string of any
length where as _ allows you to match on a single character................
SQL NOT NULL: The NOT NULL constraint enforces a column to NOT accept NULL
values..............
|
