Similar Topics

Web Technologies32.1K+ articles

Experiences15.8K+ articles

Misc7.7K+ articles

Databases1.9K+ articles

Internship1.6K+ articles

SQL1.4K+ articles

SQL-Query196+ 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: 24 August 2026

The SQL UNION ALL operator combines the result sets of two or more SELECT statements into a single output. Unlike UNION, it does not remove duplicate rows, making it faste...read more

article_image

SQL-Clauses-Operators

SQL TRUNCATE TABLE

Last Updated: 20 August 2026

The TRUNCATE TABLE statement is used to remove all records from a table while preserving its structure. It is especially useful when working with large tables.Executes fas...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: 22 August 2026

The SQL LIKE operator is used to search for a specific pattern within a column’s text data. It works with wildcard characters to match partial strings, making it useful fo...read more

article_image

SQL-Clauses-Operators

Pivot and Unpivot in SQL

Last Updated: 31 August 2026

Pivot and Unpivot in SQL are used to transform data by switching rows and columns. They help make data more readable, organized and useful for reporting and analysis.Pivot...read more

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 and EXCEPT Clauses

Last Updated: 17 November 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: 22 May 2026

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

1 2 3