SQL BLOGS

The DENSE RANK () Function is another ranking function that is used to rank the set of rows. This DENSE RANK () function assigns a unique rank to each row and the rank will reset with each partition that is

The RANK() function assigns a unique rank for each row in the result set. If two records have the same value then it will assign the same rank by skipping the next rank in the sequence. The ranking is done

Like the Aggregate function, the WINDOW Function also aggregates the values in the particular window (or, set of rows ) and it returns the aggregated values for each row. These functions use the OVER () clause to define the window

The CROSS JOIN which is also known as Cartesian Join is used to return the set of records by the Cartesian product of the joined tables. Syntax of CROSS JOIN – SELECT Table1.column1,Table2.column1,Table3.column1,…,TableN.columnN FROM Table1,Table2,…; Example – Consider these two tables

The LAST_VALUE () Function in SQL is a Value Window Function that is used to fetch the last value within the ordered partition of the set or the entire table when the partition is not defined. ORDER BY ( )

The LAG () Function is a Value Window Function used to fetch the previous row data along with the current row data of the specified offset, in other words, it is said as the LAG() Function access data of the

This Window function operates on a set of rows for the query provided. It returns the value for each row using multiple rows or only one row. The set of the row is determined by the OVER() clause. These functions

The HAVING clause in SQL is used to mention the condition to filter the result for the GROUP BY. The WHERE Clause specifies the condition for the selected column but the HAVING clause only has the condition for the GROUP

The DEFAULT constraint in SQL is used to fill up the mentioned column with default and fixed values. All the new records will have the same value if no other value is mentioned. Syntax using DEFAULT Constraint –  CREATE TABLE table_name

The CASE statement in SQL is used to evaluate a series of conditions and returns the values when the first condition is met. It is very similar to if-else statements. As the first condition came out to be TRUE, it

The CHECK constraint in SQL is used to limit the values that a column can hold in the creation of the table. The Check constraint is basically mentioned in CREATE TABLE command in SQL. If the value added column, if it violates

Duplicacy can be attained when inserting many records into the database. Adding a Primary key constraint to a column restricts the insertion of duplicate values. This action gives an error message in the console and can interrupt the operation flow.

The BETWEEN operator in SQL returns the values within the given range. The range can be text, number, or dates. The Between operators are inclusive which means the starting value and the ending values are included. Syntax of BETWEEN Operator

The GROUP BY clause is used by the SELECT statement to arrange the same values rows in groups. These clauses often use aggregated functions such as AVG(), SUM(), COUNT(), etc. to group the results of one or more columns. The

The UNION operator is used to combine the results of two or more SELECT statements and return the value without any duplicate values. To use this operator in the SELECT Statements, the SELECT should have – Every SELECT statement should

SQL RIGHT JOIN returns all the records from the right table even if there is no match of the records with the right table. If there are no records found then the result set will carry NULL on the non-matched

The LEFT JOIN or LEFT OUTER JOIN is used to retrieve all the records from the Left table (Table A) if there is no match with the Right table (Table B). If there is no match in the right table

The SELF JOIN is used to join the table to itself, assuming it as two tables. Syntax of SELF JOIN – SELECT A.column_name,B.column_name,… FROM Table A ,Table B WHERE condition ; Example – Consider the Product table to use Self join.

INNER JOIN is the most frequently used join in SQL. These joins are also referred to as EQUIJOIN. It creates a new result set that comprises the matching records of the joined tables on the basis of joining ground. If

The SQL Joins are used to combine the data from two or more tables on the basis of some related columns of each. Suppose, we want to join Peoples Table and Product Table to learn about the regional manager of

The IN Operator in SQL is used to return the result that matches the specified values in the WHERE clause. Like the OR Operator, the IN operator works the same. For multiple OR operators, the IN operator can be used

The ORDER BY keyword is used to sort the values in Ascending [ASC] or Descending [DESC] order. The default sorting in the ORDER BY keyword is in Ascending Order. To sort it in descending order, we need to add [DESC]

These Aggregate functions are used in SQL to do operation on the values of the columns and it returns a single value for the respective column. These Functions are built-in SQL and are used for doing different operations in SQL.