SQL
INDEX in SQL
Introduction The database search engine can use indexes, which are specialised lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book's back matter index quite a bit. For instance, if you want to find
DDL and DML Commands: Explanation and Differences
Introduction Have you heard something like DDL commands? Do you know how we can use DML commands? If not, then don't worry. Board Infinity will help you to clear all these doubts. In this article, we will discuss DDL and DML commands. We will discuss what those commands are and
ORDER BY in SQL
Introduction This article mainly explains the ORDER BY clause present in MySQL. ORDER BY clause is generally used to sort the fetched data from the query in ascending or descending order for one or more columns from the database table. The default order used in the ORDER BY clause is
GROUP BY in SQL
Introduction Finding summary rows, such as "find the number of consumers in each country," is done with the GROUP BY statement, which groups rows with similar values. The COUNT(), MAX(), MIN(), SUM(), and AVG() aggregate functions are frequently used with the GROUP BY statement to group the result set by
SQL Window Function
Introduction Window functions apply ranking and aggregation functions over a certain window (set of rows). The window is defined by the OVER clause when used with window functions. the following two things: * divides rows into groups called sets. (The clause "PARTITION BY" is utilised.) * rows within such partitions are put
SQL: Is it a Programming Language?
Introduction Structured Query Language, or SQL can be used to access and manage databases. In 1986, the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) both recognised SQL as a standard.SQL is capable of running queries against databases.From a database, SQL may obtain information.
SELF JOIN IN SQL
Introduction You can link a table to itself using a self join. It makes it easier to compare rows inside the same database or query hierarchical data. The inner join or left join clause is used in a self join. The table is referenced by the self join query, which
PostgreSQL - Commands
Postgresql commands - psql commands Psql is a terminal that may be used to interface with the PostgreSQL database. It is used to more quickly and efficiently query data from the PostgreSQL database server. We'll examine some of the most used Psql commands. Below is a table containing the most
SQL WITH Clause – Tutorial and Examples
Introduction WITH Clause in SQL was introduced by Oracle in the Oracle 9i release. It was introduced to simplify complex queries which include joins, and nested queries. Sub queries. WITH clause in SQL is used in hand with CTE( Common Table Expressions) and is also called subquery refactoring. This WITH
Difference Between SQL and NoSQL
Introduction There are two types of data structures present i.e relational database and non-relational database. The main difference between SQL and NoSQL is SQL is a relational database language(RDBMS) whereas NoSQL is a non-relational database language or distributed. This article mainly explains the differences between SQL and NoSQL.
