Alias Syntax in SQL

Alias Syntax in SQL

Aliasing is used to rename the table or columns in the query. This type of renaming is temporary and has scope only when query...
Indexes in SQL

Indexes in SQL

Let us consider the library database to understand the examples described below : Figure 1: Library Database Indexes are used for the faster retrieval of records....
Alter Command in SQL

Alter Command in SQL

Tables created in a database need not be perfect. We may later find requirement for some new columns, or some columns as irrelevant, or...
Using Views in SQL

Using Views in SQL

Views are the named queries, acting like a table. When a complex query is used multiple times, part of the query can be kept...
Having Clause in SQL

Having Clause in SQL

This is used along with GROUP BY clause to check the conditions on its function outputs like COUNT, SUM, MAX, MIN, AVG etc. we...
SQL Transactions in SQL

SQL Transactions in SQL

SQL transaction is a set of actions performed on a table or tables. These transactions usually modify the data in the table. In order...
Wildcards in SQL

Wildcards in SQL

When we write queries, we might not know the whole details about the data we are searching for. Sometimes we may require list of...
Date Functions in SQL

Date Functions in SQL

    Date is one of the important datatype in database. It cannot be manipulated like we do numbers or characters. We need separate functions for...
Temporary Tables in SQL

Temporary Tables in SQL

In SQL, temporary tables are used to hold the backup of table temporarily, or store intermediary result in a table. These kinds of tables...
Sub Queries In SQL

Sub Queries In SQL

Sub queries are queries inside queries. These sub queries are used in the query to get required details for the main query from some...

Stay connected

9,228FansLike

Latest article

Multiplication of two matrices

Multiplication of two matrices

Given two matrices, this function will multiply the two matrices and prints the result. Here, necessary and sufficient condition is the number of columns...
Subtraction of two matrices

Subtraction of two matrices

Given two matrices, we will write a function that subtracts the given matrices. Example INPUT A = { {1, 4, 7, 9}, {1, 6, 7, 6}, {6, 3, 7,...
Check if two given matrices are identical

Check if two given matrices are identical

Given two matrices, we will write a function to check whether the two matrices are identical or not. That is, if all the elements...