Similar Topics

Web Technologies32.1K+ articles

Experiences15.8K+ articles

Misc7.7K+ articles

Databases2.0K+ articles

Internship1.6K+ articles

SQL1.4K+ articles

SQL-Query194+ articles

dbms51+ articles

SQLmysql50+ articles

DBMS-Join14+ articles

SQL-Clauses-Operators

38 posts

SQL Left Outer Join vs Left Join

Last Updated: 23 July 2025

In SQL, LEFT JOIN and LEFT OUTER JOIN are among the most commonly used join operations to combine data from multiple tables. These terms are interchangeable, as both retri...read more

SQL-Clauses-Operators

Last Updated: 23 July 2025

UNION ALL Operator is used to combine the results of two or more SELECT statements into a single result set. Unlike the UNION operator, which eliminates duplicate records ...read more

SQL-Clauses-Operators

SQL TRUNCATE TABLE

Last Updated: 23 July 2025

The TRUNCATE TABLE statement in SQL is a powerful command used to swiftly remove all rows from a table, leaving the table structure intact. This operation is often favored...read more

article_image

SQL-Clauses-Operators

SQL DROP CONSTRAINT

Last Updated: 23 July 2025

In SQL, constraints are used to ensure data integrity and define rules for the data in our database tables. These rules include ensuring uniqueness, maintaining referentia...read more

article_image

SQL-Clauses-Operators

SQL LIKE Operator

Last Updated: 23 July 2025

The SQL LIKE operator is used for performing pattern-based searches in a database. It is used in combination with the WHERE clause to filter records based on specified pat...read more

SQL-Clauses-Operators

Pivot and Unpivot in SQL

Last Updated: 12 July 2025

In SQL, PIVOT and UNPIVOT are powerful operations used to transform data and make it more readable, efficient, and manageable. These operations allow us to manipulate tabl...read more

article_image

SQL-Clauses-Operators

SQL | With Ties Clause

Last Updated: 21 March 2018

This post is a continuation of SQL Offset-Fetch ClauseNow, we understand that how to use the Fetch Clause in Oracle Database, along with the Specified Offset and we also u...read more

SQL-Clauses-Operators

SQL | Alternative Quote Operator

Last Updated: 21 March 2018

This post is a continuation of the SQL Concatenation Operator.Now, suppose we want to use apostrophe in our literal value but we can't use it directly.See Incorrect code:S...read more

SQL-Clauses-Operators

SQL USING Clause

Last Updated: 15 September 2025

The SQL USING clause is an important feature that simplifies join operations between tables. It allows you to directly specify the column(s) that both tables have in commo...read more

article_image

Technical Scripter

SQL-Clauses-Operators

SQL | Intersect & Except clause

Last Updated: 29 August 2025

In SQL, INTERSECT and EXCEPT are set operations used to compare results from two SELECT statements. INTERSECT returns only the rows that are common to both queries. EXCEPT...read more

SQL-Clauses-Operators

SQL MERGE Statement

Last Updated: 09 May 2024

SQL MERGE Statement combines INSERT, DELETE, and UPDATE statements into one single query.MERGE Statement in SQLMERGE statement in SQL is used to perform insert, update, an...read more

article_image

SQL-Clauses-Operators

SQL Server MERGE Statement

Last Updated: 14 July 2025

SQL Server MERGE statement combines INSERT, UPDATE, and DELETE operations into a single transaction.MERGE in SQL ServerThe MERGE statement in SQL provides a convenient way...read more

SQL-Clauses-Operators

SQL Commands | DDL, DQL, DML, DCL and TCL Commands

Last Updated: 23 September 2025

SQL commands are fundamental building blocks used to perform given operations on database. The operations include queries of data. creating a table, adding data to tables,...read more

article_image

SQL-Clauses-Operators

SQL | DESCRIBE Statement

Last Updated: 10 May 2023

Prerequisite: SQL Create ClauseAs the name suggests, DESCRIBE is used to describe something. Since in a database, we have tables, that's why do we use DESCRIBE or DESC(bot...read more

article_image

SQL-Clauses-Operators

SQL | Concatenation Operator

Last Updated: 06 January 2025

The SQL concatenation operator (||) is a powerful feature that allows us to merge two or more strings into a single output. It is widely used to link columns, character st...read more

article_image

SQL-Clauses-Operators