Category Archives: SQL

SQL Correlated Subqueries

Correlated subqueries are used for row-by-row processing. Each subquery is executed once for every row of the outer query. A correlated subquery is evaluated once… Read More »

SQL | With Ties Clause

This post is a continuation of SQL Offset-Fetch Clause Now, we understand that how to use the Fetch Clause in Oracle Database, along with the… Read More »

SQL | Datatypes

Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below.   1. Binary Datatypes… Read More »

SQL | Concatenation Operator

Prerequisite: Basic Select statement, Insert into clause, SQL Create Clause, SQL Aliases || or concatenation operator is use to link columns or character strings. We… Read More »