SQL

What is SQL?

SQL stands for Structured Query Language. It is a standard language for storing, manipulating and retrieving of data in databases. It is just a query language and not a database. Also, it can work with MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Why is SQL Required?

SQL is required to query databases and perform the following operations:

  • Store data in databases.
  • Fetch data from databases.
  • Updating records in databases.

Recent Articles

SQL Sum Function | Sum a Column of Rows Matching a Criteria
SQL Sum is an inbuilt function in SQL Server. It returns the sum of a particular field/column in the rows matching criteria. Also, it can return the sum of all the fields of all rows in the table if you don't specify any criteria. In this article, we will discuss ...
Read More
SQL SIGN Function | Return Sign of a Number
SQL SIGN is an inbuilt Math Function in SQL Server. It returns the sign of a number (1 if the number if positive, -1 for negative). In this article, we will discuss the SQL SIGN Function. Also, we will discuss a few examples of using it. Syntax SIGN (number) Parameters ...
Read More
SQL UNION Operator | Combine Separate SQL Statements
The SQL UNION operator combines the result of two or more SQL SELECT queries and returns the combined result of the queries as a union. In this article, we will discuss the SQL Union Clause. Also, we will discuss a few examples of using it. Syntax SELECT column1, column2 ...
Read More
SQL RIGHT JOIN
SQL RIGHT JOIN statement returns all the records present in the right table and matched records from the left table. However, the result will contain null for the rows which are not present in the left table. In this article, we will discuss the SQL RIGHT JOIN Statement. Also, we ...
Read More
SQL LEFT JOIN
SQL LEFT JOIN statement returns all the records present in the left table and matched records from the right table. However, the result will contain null for the rows which are not present in the right table. In this article, we will discuss the SQL LEFT JOIN Statement. Also, we ...
Read More
SQL INNER JOIN
SQL INNER JOIN statement selects data present in both (or more) tables according to the common field between them. It matches all the rows in table 1 with all the rows with table 2 for the JOIN condition and returns all the pair of rows which match the criteria. Therefore, ...
Read More
SQL Aliases | Temporary Name to Column or Table
Aliases in SQL are temporary names you can give to a table or column for a particular SQL Query. They are useful when original names are very big or not readable. However, the temporary name only exists for the duration of the query. In this article, we will discuss SQL ...
Read More
SQL BETWEEN Operator | Select Value Within Given Range
SQL BETWEEN is an inbuilt operator in SQL Server. It returns the rows within a given range of a certain column. You can use it with the WHERE Condition in the query. Also, the values can be numbers, text or timestamp. In this article, we will discuss the SQL BETWEEN ...
Read More
SQL IN Operator | Multiple Values in WHERE Condition
The SQL IN Operator allows us to specify multiple values in the WHERE Condition. It removes the need for multiple OR conditions in queries. Therefore, you can provide a list of values to search in the table. In this article, we will discuss the IN Operator in SQL. Also, we ...
Read More
SQL AVG Function | Average Value of Expression
SQL AVG is an inbuilt function in SQL Server. It returns the average of a particular field/column in the rows matching criteria. Also, it can return the average of all the fields of all rows in the table if you don't specify any criteria. In this article, we will discuss ...
Read More