SQL LIKE - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
Explain the SQL LIKE statement. Write SQL syntax for the SQL LIKE statement
along with an example.
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.
Syntax:
SELECT * FROM table_name WHERE column_name like 'pattern%';
Example:
SELECT * FROM employee WHERE emp_name like 'ma%';
SQL EXISTS: If the subquery returns at least one row the EXISTS condition is
considered "to be met"...............
SQL CONCATENATE: This clause combine together (concatenate) the results from
several different fields...............
SQL INTERSECT allows combining results of two or more select queries. If a
record exists in one query and not in the other, it will be omitted from the
INTERSECT results..............
SELECT DISTINCT: It is used to select unique records from a table. Some tables
may have duplicate values for a column. Distinct will eliminate these
duplications...........
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 ................
|
