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 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
SQL Count Function | Count Rows Matching a Criteria
SQL Count is an inbuilt function in SQL Server. It returns the count of the number of rows matching criteria. Also, it can return the count of all the rows in the table if you don't specify any criteria. In this article, we will discuss the SQL Count Function. Also, ...
Read More
SQL MAX Function | Return Largest Value in Column
SQL MAX is an inbuilt function in SQL Server. It returns the largest value of a column in a table. It finds the record which has the maximum value in a recordset. In this article, we will discuss the SQL MAX Function. Also, we will discuss an example of using ...
Read More