Similar Topics

Difference Between

4.3k+ articles

1.2k+ articles

1.2k+ articles

510+ articles

470+ articles

40+ articles

20+ articles

10+ articles

10+ articles

SQL-Clauses-Operators

40+ posts

Popular articles

Recent articles

Pivot and Unpivot in SQL

Last Updated: 24 July 2019

In SQL, Pivot and Unpivot are relational operators that are used to transform one table into another in order to achieve more simpler view of table. Conventionally we can ...read more

SQL-Clauses-Operators

SQL | USING Clause

Last Updated: 21 March 2018

If several columns have the same names but the datatypes do not match, the NATURAL JOIN clause can be modified with the USING clause to specify the columns that should be ...read more

SQL-Clauses-Operators

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

Last Updated: 10 May 2023

Structured Query Language(SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can use t...read more

SQL-Clauses-Operators

Similar Topics

Difference Between

4.3k+ articles

1.2k+ articles

1.2k+ articles

510+ articles

470+ articles

40+ articles

20+ articles

10+ articles

10+ articles

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

SQL-Clauses-Operators

SQL | MINUS Operator

Last Updated: 14 September 2023

The Minus Operator in SQL is used with two SELECT statements. The MINUS operator is used to subtract the result set obtained by first SELECT query from the result set obta...read more

SQL-Clauses-Operators

ALTER (RENAME) in SQL

Last Updated: 04 September 2023

Sometimes we may want to rename our table to give it a more relevant name. For this purpose, we can use ALTER TABLE to rename the name of the table. SQL ALTER TABLE is a c...read more

SQL-Clauses-Operators

SQL ALTER TABLE - ADD, DROP, MODIFY

Last Updated: 05 April 2023

The ALTER TABLE statement in SQL is used to add, remove, or modify columns in an existing table. The ALTER TABLE statement is also used to add and remove various constrain ...read more

SQL-Clauses-Operators

Last Updated: 06 May 2023

The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. i.e. if a particular column has the same values in different r...read more

SQL-Clauses-Operators

DROP and TRUNCATE in SQL

Last Updated: 04 September 2023

SQL commands are broadly classified into two types DDL, DML here we will be learning about DDL commands, and in DDL we will be learning about DROP and TRUNCATE in this art...read more

SQL-Clauses-Operators

SQL CREATE TABLE

Last Updated: 30 August 2023

In the SQL database for creating a table, we use a command called CREATE TABLE.SQL CREATE TABLE StatementA Table is a combination of rows and columns. For creating a table...read more

SQL-Clauses-Operators

SQL | Join (Cartesian Join & Self Join)

Last Updated: 11 September 2023

SQL| JOIN(Inner, Left, Right and Full Joins)In this article, we will discuss about the remaining two JOINS: CARTESIAN JOIN SELF JOINConsider the two tables below:S...read more

SQL-Clauses-Operators

SQL | Join (Inner, Left, Right and Full Joins)

Last Updated: 11 September 2023

SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.Different types of Joins are as follows:INNER JOINLEFT JOIN...read more

SQL-Clauses-Operators

ORDER BY in SQL

Last Updated: 31 August 2023

The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns.In this article, we will discuss differen...read more

SQL-Clauses-Operators

SQL | UPDATE Statement

Last Updated: 05 April 2023

The UPDATE statement in SQL is used to update the data of an existing table in the database. We can update single columns as well as multiple columns using the UPDATE stat...read more

SQL-Clauses-Operators

SQL INSERT INTO Statement

Last Updated: 12 April 2023

The INSERT INTO statement of SQL is used to insert a new row/record in a table. There are two ways of using the SQL INSERT INTO statement for inserting rows.SQL INSERT Que ...read more

SQL-Clauses-Operators