Mindsforest

Home / SQL

Showing posts with label SQL. Show all posts

LISTAGG in Oracle

Syntax Description of the illustration listagg.gif Purpose For a specified measure, LISTAGG orders data within each group specifie...

Syntax Description of the illustration XMLAgg.gif Purpose XMLAgg is an aggregate function. It takes a collection of XML fragments ...

SQL SERVER: REPLACE FUNCTION This SQL Server tutorial explains how to use the REPLACE function in SQL Server (Transact-SQL) with syn...

Types of commands in Structured Query Language (SQL): Data Definition Language (DDL): Create, Alter, Drop, Truncate, Rename Data R...

An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. SQL EXPRESSIONs are like fo...

What is an Operator in SQL? An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perfo...