Skip to content

Tag Archives: SQL-Clauses

1. WHERE Clause: WHERE Clause is used to filter the records from the table or used while joining more than one table.Only those records will… Read More
1. DELETE : 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… Read More
Prerequisite – DROP, and TRUNCATE in SQL 1. DROP : DROP is a DDL(Data Definition Language) command and is used to remove table definition and… Read More
JOIN: JOIN in SQL is used to combine data from many tables based on a matched condition between them. The data combined using JOIN statement… Read More
1. COMMIT : COMMIT in SQL is a transaction control language which is used to permanently save the changes done in the transaction in tables/databases.… Read More
Consider a table STUDENT having the following schema: STUDENT (Student_id, Student_Name, Address, Marks) Student_id is the primary column of STUDENT table. Let first create the… Read More
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… Read More
Prerequisite – Aggregate functions in SQL, Joins in SQL Aggregate functions perform a calculation on a set of values and return a single value. Now,… Read More
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… Read More