SQL CONCATENATE - Overview, syntax

SQL CONCATENATE - Introduction and syntax

---

<<Previous  Next>>

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

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

SQL CONCATENATE: This clause combine together (concatenate) the results from several different fields.

Syntax:
CONCAT(str1, str2, str3, ...):

Example:
SELECT CONCAT(first_name, last_name) FROM employee WHERE salary > 1000

SQL CREATE VIEW

SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns, just like a real table..............

SQL HAVING

HAVING clause is used to specify some condition along with aggregate functions............ 

SQL LIKE

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 ORDER BY

ORDER BY: It is used to sort columns of a result set. It sorts columns in ascending order by default. DESC can be used to sort in a descending order..............

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

SQL UNION: The UNION operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement................

<<Previous  Next>>