Similar Topics

Web Technologies

37.8k+ articles

Difference Between

4.3k+ articles

Misc

2.6k+ articles

GATE CS

1.5k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

DBMS-SQL

510+ articles

mysql

310+ articles

Oracle

290+ articles

DBMS-Join

14 articles

SQL-Clauses

14 posts

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...read more

Order of Execution of SQL Queries

Last Updated: 08 September 2023

Structured Query Language (SQL) is a standard language for managing relational databases. For any SQL query, the SQL Engine will execute the...read more

SQL - TOP, LIMIT, FETCH FIRST Clause

Last Updated: 23 June 2023

The Structured Query Language is a computer language that we use to interact with a relational database.SQL is a tool for organizing, managi...read more

Similar Topics

Web Technologies

37.8k+ articles

Difference Between

4.3k+ articles

Misc

2.6k+ articles

GATE CS

1.5k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

DBMS-SQL

510+ articles

mysql

310+ articles

Oracle

290+ articles

DBMS-Join

14+ articles

Difference Between JOIN, IN and EXISTS Clause in SQL

Last Updated: 19 May 2021

SEQUEL widely known as SQL, Structured Query Language is the most popular standard language to work on databases. We can perform tons of ope...read more

Difference Between

SQL - SELECT DATE

Last Updated: 19 May 2021

In Microsoft SQL Server, SELECT DATE is used to get the data from the table related to the date, the default format of date is 'YYYY-MM-DD'....read more

SQL - SELECT IN

Last Updated: 20 May 2021

IN operator is a membership operator which returns values that match the values in a list or subquery. Using this operator we can specify mu...read more

Difference between Where and Having Clause in SQL

Last Updated: 06 March 2024

WHERE and HAVING clauses play an important role in refining the result set of a query. While both clauses are used for filtering data, they ...read more

Difference Between

Difference between DELETE and TRUNCATE

Last Updated: 03 October 2023

DELETE is a DML(Data Manipulation Language) command and is used when we specify the row (tuple) that we want to remove or delete from the ta...read more

Difference Between

Difference between DROP and TRUNCATE in SQL

Last Updated: 16 April 2020

Prerequisite - DROP, and TRUNCATE in SQL1. DROP :DROP is a DDL(Data Definition Language) command and is used to remove table definition and ...read more

Difference Between

Difference between JOIN and UNION in SQL

Last Updated: 15 March 2023

Pre-requisites: JOIN, UNIONJOIN in SQL is used to combine data from many tables based on a matched condition between them. The data combined...read more

Difference Between

Difference between COMMIT and ROLLBACK in SQL

Last Updated: 24 February 2022

1. COMMIT-COMMIT in SQL is a transaction control language that is used to permanently save the changes done in the transaction in tables/dat...read more

Difference Between

SQL query using COUNT and HAVING clause

Last Updated: 13 May 2022

Consider a table STUDENT having the following schema:STUDENT (Student_id, Student_Name, Address, Marks) Student_id is the primary column of ...read more

MySQL | PARTITION BY Clause

Last Updated: 06 March 2019

A PARTITION BY clause is used to partition rows of table into groups. It is useful when we have to perform a calculation on individual rows ...read more

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 c...read more

Technical Scripter