SQL IN - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
Explain the SQL IN statement. Write SQL syntax for the SQL IN statement along
with an example.
The IN operator allows you to specify multiple values in a
WHERE clause.
Syntax:
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)
Example:
SELECT * FROM employee
WHERE emp_LastName IN ('james','jones')
SQL BETWEEN
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..............
SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns,
just like a real table..............
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..............
SQL UNION ALL: The UNION ALL operator is used to combine the result-set of two
or more SELECT statements Tables of both the select statement ................
|
