Courses
Tutorials
Interview Prep
DSA
Practice Problems
C
C++
Java
Python
JavaScript
Data Science
Machine Learning
Courses
Linux
DevOps
Similar Topics
Web Technologies
32.1K+ articles
DSA
20.4K+ articles
Python
19.6K+ articles
Experiences
15.8K+ articles
Interview Experiences
14.5K+ articles
School Learning
11.1K+ articles
SQL
1.4K+ articles
DBMS-SQL
531+ articles
mysql
355+ articles
MySQL
290+ articles
SQL-Clauses
15 posts
Recent Articles
Popular Articles
SELECT TOP Clause
Last Updated: 29 January 2026
The SELECT TOP clause in SQL only returns the specified number of rows from the table. It is valuable on enormous tables with a large number of records. Returning countles...
read more
SQL
SQL-Clauses
Cartesian Join
Last Updated: 11 September 2023
In SQL, a Cartesian Join is also called a Cross Join, it performs the cartesian product of records of two or more joined tables. A Cartesian product matches each row of on...
read more
SQL
Picked
SQL-Clauses
Order of Execution of SQL Queries
Last Updated: 21 January 2026
SQL queries are often explained using a specific order of execution, but this order should be understood as a logical processing order, not the actual execution sequence. ...
read more
SQL
DBMS-SQL
SQL-Clauses
SQL TOP, LIMIT, FETCH FIRST Clause
Last Updated: 10 November 2025
The SQL TOP, LIMIT, and FETCH FIRST clauses are used to restrict the number of rows returned by a query. They help in retrieving only a small portion of data from a large ...
read more
SQL
Picked
SQL-Clauses
Databases
SQL SELECT IN Statement
Last Updated: 02 May 2026
The IN operator is used to check whether a column’s value matches any value in a given list.It is used to:Compare a column with multiple values at once.Return TRUE if a ma...
read more
SQL
Picked
SQL-Clauses
Databases
SQL - SELECT DATE
Last Updated: 23 July 2025
SQL (Structured Query Language) can work with datetime data types. SELECT DATE is an important concept when retrieving records that filter data based on date. Whether you ...
read more
SQL
Picked
SQL-Clauses
Databases
Difference Between JOIN, IN and EXISTS Clause in SQL
Last Updated: 23 July 2025
SEQUEL widely known as SQL, Structured Query Language is the most popular standard language to work on databases. We can perform tons of operations using SQL which include...
read more
Difference Between
SQL
Picked
SQL-Clauses
WHERE vs HAVING Clause in SQL
Last Updated: 25 August 2025
WHERE is used to filter rows before any grouping or aggregation happens, while HAVING is used to filter groups or aggregated results after GROUP BY.WHERE Clause in SQLWHER...
read more
SQL
Picked
SQL-Clauses
Difference between DELETE and TRUNCATE
Last Updated: 11 February 2026
DELETE and TRUNCATE are SQL commands are used to remove data from tables, but they differ in behavior and performance. They are used to:DELETE remove selected rows using a...
read more
SQL
SQL-Clauses
Difference between DROP and TRUNCATE in SQL
Last Updated: 12 July 2025
In SQL, the DROP and TRUNCATE commands are used to remove data, but they operate differently. DROP deletes an entire table and its structure, while TRUNCATE removing only ...
read more
SQL
SQL-Clauses
Difference Between COMMIT and ROLLBACK in SQL
Last Updated: 04 December 2025
In SQL, transaction control is essential for managing changes in a database effectively. COMMIT and ROLLBACK are two crucial Transaction Control Language (TCL) commands th...
read more
SQL
Picked
SQL-Clauses
Difference between JOIN and UNION in SQL
Last Updated: 12 July 2025
Pre-requisites: JOIN, UNIONJOIN in SQL is used to combine data from many tables based on a matched condition between them. The data combined using the JOIN statement resul...
read more
DBMS
Difference Between
GATE CS
Picked
SQL-Clauses
DBMS-Join
How to Use GROUP BY and HAVING in SQL?
Last Updated: 12 July 2025
The GROUP BY and HAVING clauses in SQL are two of the most powerful tools available for summarising and analysing data. These clauses enable developers and analysts to eff...
read more
SQL
DBMS-SQL
SQL-Clauses
MySQL PARTITION BY Clause
Last Updated: 25 March 2026
The PARTITION BY clause in MySQL divides the result set into smaller groups so calculations can be performed independently within each group. It is mainly used with window...
read more
DBMS-SQL
mysql
SQL-Clauses
MySQL
SQL | ON Clause
Last Updated: 13 May 2018
The join condition for the natural join is basically an EQUIJOIN of all columns with same name. To specify arbitrary conditions or specify columns to join, the ON Clause i...
read more
Misc
Technical Scripter
SQL
Oracle
SQL-Clauses